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 1359: po_line_locations POLL

1355: l_stmt_num := 40;
1356: SELECT MSI.inventory_asset_flag
1357: INTO l_asset_flag
1358: FROM mtl_system_items MSI,
1359: po_line_locations POLL
1360: WHERE MSI.inventory_item_id = p_rcv_event.item_id
1361: AND MSI.organization_id = POLL.ship_to_organization_id
1362: AND POLL.line_location_id = p_rcv_event.po_line_location_id;
1363: EXCEPTION

Line 1477: FROM po_line_locations POLL

1473: ELSIF (p_rcv_event.event_source = 'RECEIVING' OR p_rcv_event.event_source = 'RETROPRICE') THEN
1474: l_stmt_num := 70;
1475: SELECT POLL.price_override
1476: INTO l_unit_price
1477: FROM po_line_locations POLL
1478: WHERE POLL.line_location_id = p_rcv_event.po_line_location_id;
1479:
1480: /* Support for Landed Cost Management */
1481: IF (p_rcv_event.event_source = 'RECEIVING' AND p_lcm_flag = 'Y') THEN

Line 2235: FROM po_line_locations

2231:
2232: l_stmt_num := 30;
2233: SELECT match_option
2234: INTO l_match_option
2235: FROM po_line_locations
2236: WHERE line_location_id = l_po_line_location_id;
2237:
2238: -- Always use rate on the PO distribution for encumbrance reversals.
2239: IF (l_match_option = 'P' OR (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL)) THEN

Line 3235: FROM po_line_locations POLL

3231: -- accounting API.
3232: l_stmt_num := 20;
3233: SELECT nvl(poll.accrue_on_receipt_flag, 'N')
3234: INTO l_accrue_on_receipt_flag
3235: FROM po_line_locations POLL
3236: WHERE POLL.line_location_id = p_rcv_events_tbl(l_ctr_first).po_line_location_id;
3237:
3238: FOR i IN p_rcv_events_tbl.FIRST..p_rcv_events_tbl.LAST LOOP
3239: l_stmt_num := 30;

Line 4408: po_line_locations POLL,

4404: l_inv_trx.parent_transaction_flag,
4405: l_inv_trx.trx_source_line_id
4406: FROM rcv_transactions RT,
4407: po_lines POL,
4408: po_line_locations POLL,
4409: po_distributions POD,
4410: fnd_currencies FC
4411: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
4412: AND POL.po_line_id = p_rcv_event.po_line_id