[Home] [Help]
128: ( rt.transaction_type = 'MATCH'))
129: )
130: AND NOT EXISTS ( SELECT 1
131: FROM RCV_TRANSACTIONS RT,
132: PO_DISTRIBUTIONS_ALL POD
133: WHERE RT.TRANSACTION_ID = AIDA.RCV_TRANSACTION_ID
134: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
135: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE'
136: )
187: ( rt.transaction_type = 'MATCH'))
188: )
189: AND NOT EXISTS ( SELECT 1
190: FROM RCV_TRANSACTIONS RT,
191: PO_DISTRIBUTIONS_ALL POD
192: WHERE RT.TRANSACTION_ID = AIDA.RCV_TRANSACTION_ID
193: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
194: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE' )
195: /*bug 5044215/5264793.Only pick up receipts that have delivers */
239: AND rae.event_type_id = 1 -- RECEIVE
240: AND rae.trx_flow_header_id is not NULL)
241: AND NOT EXISTS ( SELECT 1
242: FROM rcv_transactions rt,
243: po_distributions_all pod,
244: po_line_locations_all poll
245: WHERE rt.transaction_id = aida.rcv_transaction_id
246: AND pod.line_location_id = rt.po_line_location_id
247: AND poll.line_location_id = rt.po_line_location_id
620: l_rae_trf_price_flag
621: From rcv_accounting_events rae,
622: po_lines_all POL,
623: po_line_locations_all POLL, -- Added for Complex work Procurement
624: po_distributions_all POD
625: Where rae.rcv_transaction_id = c_rec.transaction_id
626: And rae.event_type_id = 1 -- RECEIVE
627: And rae.trx_flow_header_id is not null
628: AND RAE.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
1892: c_rec.inventory_item_id,
1893: l_new_landed_cost unit_price,
1894: l_prior_landed_cost,
1895: 1
1896: FROM po_distributions_all pod
1897: WHERE pod.line_location_id = c_rec.line_location_id);
1898: END IF;
1899: /* NOW INSERT THE RAE FOR DELIVERY */
1900: FOR C_REC2 IN c_lcm_del(c_rec.rcv_transaction_id,
2413: l_rae_trf_price_flag
2414: From rcv_accounting_events rae,
2415: po_lines_all POL,
2416: po_line_locations_all POLL, -- Added for Complex work Procurement
2417: po_distributions_all POD
2418: Where rae.rcv_transaction_id = c_rec.transaction_id
2419: And rae.event_type_id = 1 -- RECEIVE
2420: And rae.trx_flow_header_id is not null
2421: AND RAE.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
4781: 'QUANTITY', POD.quantity_ordered ) ) ), 0 )
4782: INTO
4783: l_tot_tax
4784: FROM
4785: po_distributions_all pod,
4786: rcv_transactions rcv,
4787: po_line_locations_all pll
4788: WHERE RCV.TRANSACTION_ID = i_rcv_txn_id
4789: AND POD.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID
4844: l_trx_flow,
4845: l_org_id
4846: From rcv_accounting_events rae,
4847: po_lines_all POL,
4848: po_distributions_all POD
4849: Where rae.rcv_transaction_id = i_rcv_txn_id
4850: And rae.event_type_id = 1 -- RECEIVE
4851: And rae.trx_flow_header_id is not null
4852: AND RAE.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
4902: /SUM(DECODE(POLL.MATCHING_BASIS, 'AMOUNT', POD.AMOUNT_ORDERED, POD.QUANTITY_ORDERED))
4903: INTO
4904: l_po_rate
4905: FROM
4906: PO_DISTRIBUTIONS_ALL POD,
4907: RCV_TRANSACTIONS RT,
4908: PO_LINE_LOCATIONS_ALL POLL
4909: WHERE
4910: RT.TRANSACTION_ID = i_rcv_txn_id