DBA Data[Home] [Help]

APPS.CSTPPACQ dependencies on PO_LINES_ALL

Line 557: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;

553: l_inv_count number;
554: l_header cst_rcv_acq_costs.header_id%TYPE;
555: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
556: l_po_uom mtl_units_of_measure.uom_code%TYPE;
557: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
558: l_po_price po_lines_all.unit_price%TYPE;
559: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
560: l_po_line_loc po_lines_all.po_line_id%TYPE;
561: l_item_id mtl_system_items.inventory_item_id%TYPE;

Line 558: l_po_price po_lines_all.unit_price%TYPE;

554: l_header cst_rcv_acq_costs.header_id%TYPE;
555: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
556: l_po_uom mtl_units_of_measure.uom_code%TYPE;
557: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
558: l_po_price po_lines_all.unit_price%TYPE;
559: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
560: l_po_line_loc po_lines_all.po_line_id%TYPE;
561: l_item_id mtl_system_items.inventory_item_id%TYPE;
562: l_org_id rcv_transactions.organization_id%TYPE;

Line 560: l_po_line_loc po_lines_all.po_line_id%TYPE;

556: l_po_uom mtl_units_of_measure.uom_code%TYPE;
557: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
558: l_po_price po_lines_all.unit_price%TYPE;
559: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
560: l_po_line_loc po_lines_all.po_line_id%TYPE;
561: l_item_id mtl_system_items.inventory_item_id%TYPE;
562: l_org_id rcv_transactions.organization_id%TYPE;
563: l_poll_quantity po_line_locations_all.quantity%TYPE;
564: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;

Line 622: po_lines_all POL,

618: Into l_accounting_event_id,
619: l_rae_unit_price,
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

Line 676: po_lines_all pol1,

672:
673: SELECT count(rt2.transaction_id)
674: INTO l_po_count
675: FROM rcv_transactions rt2,
676: po_lines_all pol1,
677: po_line_locations_all poll1
678: WHERE rt2.transaction_id = c_rec.transaction_id
679: AND rt2.po_line_location_id = poll1.line_location_id
680: AND pol1.po_line_id = poll1.po_line_id

Line 755: po_lines_all pol2,

751: l_org_id,
752: l_rate,
753: l_order_type_lookup_code
754: FROM
755: po_lines_all pol2,
756: po_line_locations_all poll3,
757: rcv_transactions rt33
758: WHERE
759: rt33.transaction_id = c_rec.transaction_id

Line 945: PO_LINES_ALL POL,

941: FROM
942: ap_invoice_distributions_all ad2,
943: -- J Changes -----------------------------------------------------------
944: RCV_TRANSACTIONS RT,
945: PO_LINES_ALL POL,
946: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
947: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
948: ------------------------------------------------------------------------
949: WHERE

Line 1208: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;

1204: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1205: l_nr_tax_rate NUMBER;
1206: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1207: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1208: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1209: l_po_price po_lines_all.unit_price%TYPE;
1210: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1211: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1212: l_item_id mtl_system_items.inventory_item_id%TYPE;

Line 1209: l_po_price po_lines_all.unit_price%TYPE;

1205: l_nr_tax_rate NUMBER;
1206: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1207: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1208: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1209: l_po_price po_lines_all.unit_price%TYPE;
1210: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1211: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1212: l_item_id mtl_system_items.inventory_item_id%TYPE;
1213: l_org_id rcv_transactions.organization_id%TYPE;

Line 1298: po_lines_all pol2,

1294: l_po_uom_code,
1295: l_org_id,
1296: l_rate
1297: FROM
1298: po_lines_all pol2,
1299: po_line_locations_all poll3,
1300: rcv_transactions rt33
1301: WHERE rt33.transaction_id = c_rec.transaction_id
1302: AND rt33.po_line_location_id = poll3.line_location_id

Line 2302: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;

2298: l_inv_count number;
2299: l_header cst_rcv_acq_costs.header_id%TYPE;
2300: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2301: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2302: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2303: l_po_price po_lines_all.unit_price%TYPE;
2304: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2305: l_po_line_loc po_lines_all.po_line_id%TYPE;
2306: l_item_id mtl_system_items.inventory_item_id%TYPE;

Line 2303: l_po_price po_lines_all.unit_price%TYPE;

2299: l_header cst_rcv_acq_costs.header_id%TYPE;
2300: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2301: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2302: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2303: l_po_price po_lines_all.unit_price%TYPE;
2304: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2305: l_po_line_loc po_lines_all.po_line_id%TYPE;
2306: l_item_id mtl_system_items.inventory_item_id%TYPE;
2307: l_org_id rcv_transactions.organization_id%TYPE;

Line 2305: l_po_line_loc po_lines_all.po_line_id%TYPE;

2301: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2302: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2303: l_po_price po_lines_all.unit_price%TYPE;
2304: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2305: l_po_line_loc po_lines_all.po_line_id%TYPE;
2306: l_item_id mtl_system_items.inventory_item_id%TYPE;
2307: l_org_id rcv_transactions.organization_id%TYPE;
2308: l_poll_quantity po_line_locations_all.quantity%TYPE;
2309: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;

Line 2415: po_lines_all POL,

2411: Into l_accounting_event_id,
2412: l_rae_unit_price,
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

Line 2469: po_lines_all pol1,

2465:
2466: SELECT count(rt2.transaction_id)
2467: INTO l_po_count
2468: FROM rcv_transactions rt2,
2469: po_lines_all pol1,
2470: po_line_locations_all poll1
2471: WHERE rt2.transaction_id = c_rec.transaction_id
2472: AND rt2.po_line_location_id = poll1.line_location_id
2473: AND pol1.po_line_id = poll1.po_line_id

Line 2548: po_lines_all pol2,

2544: l_org_id,
2545: l_rate,
2546: l_order_type_lookup_code
2547: FROM
2548: po_lines_all pol2,
2549: po_line_locations_all poll3,
2550: rcv_transactions rt33
2551: WHERE
2552: rt33.transaction_id = c_rec.transaction_id

Line 2738: PO_LINES_ALL POL,

2734: FROM
2735: ap_invoice_distributions_all ad2,
2736: -- J Changes -----------------------------------------------------------
2737: RCV_TRANSACTIONS RT,
2738: PO_LINES_ALL POL,
2739: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
2740: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
2741: ------------------------------------------------------------------------
2742: WHERE

Line 3150: FROM PO_LINES_ALL POL,

3146: l_stmt_num := 10;
3147:
3148: SELECT NVL(POLL.MATCHING_BASIS, POL.MATCHING_BASIS) -- Changed for Complex work Procurement
3149: INTO L_PO_LINE_TYPE_CODE
3150: FROM PO_LINES_ALL POL,
3151: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
3152: RCV_TRANSACTIONS RT
3153: WHERE POL.PO_LINE_ID = RT.PO_LINE_ID
3154: AND POLL.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID-- Added for Complex work Procurement

Line 4847: po_lines_all POL,

4843: Into
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