[Home] [Help]
118: AND rae.event_type_id = 1 -- RECEIVE
119: AND rae.trx_flow_header_id is not NULL)
120: AND NOT EXISTS ( SELECT 1
121: FROM rcv_transactions rt,
122: po_distributions_all pod
123: WHERE rt.transaction_id = aida.rcv_transaction_id
124: AND pod.line_location_id = rt.po_line_location_id
125: AND pod.destination_type_code = 'EXPENSE' )
126: AND EXISTS (Select 1
182: ( rt.transaction_type = 'MATCH'))
183: )
184: AND NOT EXISTS ( SELECT 1
185: FROM RCV_TRANSACTIONS RT,
186: PO_DISTRIBUTIONS_ALL POD
187: WHERE RT.TRANSACTION_ID = AIDA.RCV_TRANSACTION_ID
188: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
189: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE'
190: )
231: ( rt.transaction_type = 'MATCH'))
232: )
233: AND NOT EXISTS ( SELECT 1
234: FROM RCV_TRANSACTIONS RT,
235: PO_DISTRIBUTIONS_ALL POD
236: WHERE RT.TRANSACTION_ID = AIDA.RCV_TRANSACTION_ID
237: AND POD.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
238: AND POD.DESTINATION_TYPE_CODE = 'EXPENSE' )
239: /*bug 5044215/5264793.Only pick up receipts that have delivers */
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
1899: c_rec.inventory_item_id,
1900: l_new_landed_cost unit_price,
1901: l_prior_landed_cost,
1902: 1
1903: FROM po_distributions_all pod
1904: WHERE pod.line_location_id = c_rec.line_location_id);
1905: END IF;
1906: /* NOW INSERT THE RAE FOR DELIVERY */
1907: FOR C_REC2 IN c_lcm_del(c_rec.rcv_transaction_id,
2461: l_rae_trf_price_flag
2462: From rcv_accounting_events rae,
2463: po_lines_all POL,
2464: po_line_locations_all POLL, -- Added for Complex work Procurement
2465: po_distributions_all POD
2466: Where rae.rcv_transaction_id = l_rec_transaction_id
2467: And rae.event_type_id = 1 -- RECEIVE
2468: And rae.trx_flow_header_id is not null
2469: AND RAE.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
4926: 'QUANTITY', POD.quantity_ordered ) ) ), 0 )
4927: INTO
4928: l_tot_tax
4929: FROM
4930: po_distributions_all pod,
4931: rcv_transactions rcv,
4932: po_line_locations_all pll
4933: WHERE RCV.TRANSACTION_ID = i_rcv_txn_id
4934: AND POD.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID
4998: l_trx_flow,
4999: l_org_id
5000: From rcv_accounting_events rae/*,
5001: po_lines_all POL,
5002: po_distributions_all POD*/
5003: Where rae.rcv_transaction_id = i_rcv_txn_id
5004: And rae.event_type_id = 1 -- RECEIVE
5005: And rae.trx_flow_header_id is not null
5006: /*AND RAE.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
5143: l_trx_flow,
5144: l_org_id
5145: From rcv_accounting_events rae/*,
5146: po_lines_all POL,
5147: po_distributions_all POD*/
5148: Where rae.rcv_transaction_id = i_rcv_txn_id
5149: And rae.event_type_id = 1 -- RECEIVE
5150: And rae.trx_flow_header_id is not null
5151: /*AND RAE.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
5214: /SUM(DECODE(POLL.MATCHING_BASIS, 'AMOUNT', POD.AMOUNT_ORDERED, POD.QUANTITY_ORDERED))
5215: INTO
5216: l_po_rate
5217: FROM
5218: PO_DISTRIBUTIONS_ALL POD,
5219: RCV_TRANSACTIONS RT,
5220: PO_LINE_LOCATIONS_ALL POLL
5221: WHERE
5222: RT.TRANSACTION_ID = i_rcv_txn_id