APPS.RCV_SEEDEVENTS_PVT dependencies on PO_LINE_LOCATIONS

Line 237: po_line_locations POLL,

233: l_rcv_event.source_doc_uom,
234: l_rcv_event.currency_code
235: FROM ap_invoice_distributions APID,
236: po_distributions POD,
237: po_line_locations POLL,
238: po_lines POL,
239: po_headers POH
240: WHERE APID.invoice_distribution_id = p_inv_distribution_id
241: AND POD.po_distribution_id = APID.po_distribution_id

Line 286: po_line_locations POLL,

282: /* Support for Landed Cost Management */
283: l_rcv_event.unit_landed_cost
284: FROM rcv_transactions RT,
285: po_lines POL,
286: po_line_locations POLL,
287: po_headers POH,
288: po_distributions POD
289: WHERE RT.transaction_id = p_rcv_transaction_id
290: AND POH.po_header_id = RT.po_header_id

Line 372: FROM po_line_locations POLL

368:
369: -- Check if event is for a service line type
370: SELECT decode(POLL.matching_basis, 'AMOUNT', 'Y', 'N')
371: INTO l_rcv_event.service_flag
372: FROM po_line_locations POLL
373: WHERE POLL.line_location_id = l_rcv_event.po_line_location_id;
374:
375: l_stmt_num := 90;
376:

Line 786: po_line_locations POLL

782: RT.amount)
783: INTO l_transaction_amount
784: FROM rcv_transactions RT,
785: po_distributions POD,
786: po_line_locations POLL
787: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
788: AND POD.po_distribution_id = p_rcv_event.po_distribution_id
789: AND POLL.line_location_id = p_rcv_event.po_line_location_id;
790:

Line 1038: po_line_locations POLL,

1034: RT.source_doc_quantity * POD.quantity_ordered/POLL.quantity,
1035: RT.source_doc_quantity)
1036: INTO l_source_doc_quantity
1037: FROM rcv_transactions RT,
1038: po_line_locations POLL,
1039: po_distributions POD
1040: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
1041: AND POLL.line_location_id = p_rcv_event.po_line_location_id
1042: AND POD.po_distribution_id = p_rcv_event.po_distribution_id;

Line 1059: po_line_locations POLL,

1055: l_source_doc_quantity * POD.quantity_ordered/POLL.quantity,
1056: l_source_doc_quantity)
1057: INTO l_source_doc_quantity
1058: FROM rcv_transactions RT,
1059: po_line_locations POLL,
1060: po_distributions POD
1061: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
1062: AND POLL.line_location_id = p_rcv_event.po_line_location_id
1063: AND POD.po_distribution_id = p_rcv_event.po_distribution_id;

Line 1366: po_line_locations POLL

1362: l_stmt_num := 40;
1363: SELECT MSI.inventory_asset_flag
1364: INTO l_asset_flag
1365: FROM mtl_system_items MSI,
1366: po_line_locations POLL
1367: WHERE MSI.inventory_item_id = p_rcv_event.item_id
1368: AND MSI.organization_id = POLL.ship_to_organization_id
1369: AND POLL.line_location_id = p_rcv_event.po_line_location_id;
1370: EXCEPTION

Line 1484: FROM po_line_locations POLL

1480: ELSIF (p_rcv_event.event_source = 'RECEIVING' OR p_rcv_event.event_source = 'RETROPRICE') THEN
1481: l_stmt_num := 70;
1482: SELECT POLL.price_override
1483: INTO l_unit_price
1484: FROM po_line_locations POLL
1485: WHERE POLL.line_location_id = p_rcv_event.po_line_location_id;
1486:
1487: /* Support for Landed Cost Management */
1488: IF (p_rcv_event.event_source = 'RECEIVING' AND p_lcm_flag = 'Y') THEN

Line 2242: FROM po_line_locations

2238:
2239: l_stmt_num := 30;
2240: SELECT match_option
2241: INTO l_match_option
2242: FROM po_line_locations
2243: WHERE line_location_id = l_po_line_location_id;
2244:
2245: -- Always use rate on the PO distribution for encumbrance reversals.
2246: IF (l_match_option = 'P' OR (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL)) THEN

Line 3244: FROM po_line_locations POLL

3240: -- accounting API.
3241: l_stmt_num := 20;
3242: SELECT nvl(poll.accrue_on_receipt_flag, 'N')
3243: INTO l_accrue_on_receipt_flag
3244: FROM po_line_locations POLL
3245: WHERE POLL.line_location_id = p_rcv_events_tbl(l_ctr_first).po_line_location_id;
3246:
3247: FOR i IN p_rcv_events_tbl.FIRST..p_rcv_events_tbl.LAST LOOP
3248: l_stmt_num := 30;

Line 4417: po_line_locations POLL,

4413: l_inv_trx.parent_transaction_flag,
4414: l_inv_trx.trx_source_line_id
4415: FROM rcv_transactions RT,
4416: po_lines POL,
4417: po_line_locations POLL,
4418: po_distributions POD,
4419: fnd_currencies FC
4420: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
4421: AND POL.po_line_id = p_rcv_event.po_line_id