/* Formatted on 03-Nov-15 2:28:45 PM (QP5 v5.114.809.3010) */
SELECT *
FROM po_headers_all
WHERE segment1 = 1361170636
-- Accounting Entries for PO --
/* Formatted on 03-Nov-15 2:28:49 PM (QP5 v5.114.809.3010) */
SELECT *
FROM po_headers_all
WHERE segment1 = 1361170636
--PO Receipt --
/* Formatted on 03-Nov-15 2:28:52 PM (QP5 v5.114.809.3010) */
SELECT *
FROM rcv_transactions
WHERE po_header_id = 1182531
--RECEIVE -- RECEIVING -- rcv_receiving_sub_ledger
--DELIVER -- INVENTORY -- mtl_material_transactions
-- For DELIVER
/* Formatted on 03-Nov-15 2:28:55 PM (QP5 v5.114.809.3010) */
SELECT *
FROM mtl_material_transactions
WHERE RCV_TRANSACTION_ID IN (SELECT transaction_id
FROM rcv_transactions
WHERE po_header_id = 1182531)
-- 2699101
/* Formatted on 03-Nov-15 2:29:00 PM (QP5 v5.114.809.3010) */
SELECT *
FROM mtl_transaction_accounts
WHERE transaction_id = 18820381
-- 18820381
-- For Receive
--Accrual_Method_Flag = 'O'
--JE_SOURCE_NAME ='Purchasing'
--Transactions with accrue_on_receipt_flag ='N' ie Period End Accruals are
-- classified as:
--Accrual_Method_Flag = 'P'
--JE_SOURCE_NAME ='Purchasing'
select * from rcv_receiving_sub_ledger where RCV_TRANSACTION_ID in (select
transaction_id
from rcv_transactions
where po_header_id = 1182531 )
/* Formatted on 03-Nov-15 2:28:30 PM (QP5 v5.114.809.3010) */
SELECT jel.*
FROM gl_import_references gli,
xla_ae_lines xll,
xla_ae_headers xlh,
xla_distribution_links xld,
rcv_receiving_sub_ledger rsl,
gl_je_lines jel
WHERE gli.gl_sl_link_table = xll.gl_sl_link_table
AND gli.gl_sl_link_id = xll.gl_sl_link_id
AND xll.ae_header_id = xlh.ae_header_id
AND xld.ae_header_id = xlh.ae_header_id
AND jel.je_header_id = gli.je_header_id
AND jel.je_line_num = gli.je_line_num
AND xld.source_distribution_id_num_1 = rsl.rcv_sub_ledger_id
AND rsl.RCV_TRANSACTION_ID IN (SELECT transaction_id
FROM rcv_transactions
WHERE po_header_id = 1182531)
AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
AND xll.gl_sl_link_table = 'XLAJEL'
Did you hear there's a 12 word phrase you can tell your partner... that will induce deep emotions of love and instinctual attraction to you deep inside his chest?
ReplyDeleteThat's because hidden in these 12 words is a "secret signal" that fuels a man's instinct to love, look after and look after you with all his heart...
12 Words Will Fuel A Man's Love Impulse
This instinct is so hardwired into a man's brain that it will make him work better than ever before to take care of you.
Matter-of-fact, triggering this all-powerful instinct is so binding to getting the best ever relationship with your man that the instance you send your man one of the "Secret Signals"...
...You will instantly notice him expose his mind and heart to you in a way he haven't experienced before and he will perceive you as the one and only woman in the universe who has ever truly interested him.