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 679: po_lines_all pol1,

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

Line 758: po_lines_all pol2,

754: l_org_id,
755: l_rate,
756: l_order_type_lookup_code
757: FROM
758: po_lines_all pol2,
759: po_line_locations_all poll3,
760: rcv_transactions rt33
761: WHERE
762: rt33.transaction_id = c_rec.transaction_id

Line 952: PO_LINES_ALL POL,

948: FROM
949: ap_invoice_distributions_all ad2,
950: -- J Changes -----------------------------------------------------------
951: RCV_TRANSACTIONS RT,
952: PO_LINES_ALL POL,
953: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
954: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
955: ------------------------------------------------------------------------
956: WHERE

Line 1213: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;

1209: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1210: l_nr_tax_rate NUMBER;
1211: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1212: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1213: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1214: l_po_price po_lines_all.unit_price%TYPE;
1215: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1216: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1217: l_item_id mtl_system_items.inventory_item_id%TYPE;

Line 1214: l_po_price po_lines_all.unit_price%TYPE;

1210: l_nr_tax_rate NUMBER;
1211: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1212: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1213: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1214: l_po_price po_lines_all.unit_price%TYPE;
1215: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1216: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1217: l_item_id mtl_system_items.inventory_item_id%TYPE;
1218: l_org_id rcv_transactions.organization_id%TYPE;

Line 1303: po_lines_all pol2,

1299: l_po_uom_code,
1300: l_org_id,
1301: l_rate
1302: FROM
1303: po_lines_all pol2,
1304: po_line_locations_all poll3,
1305: rcv_transactions rt33
1306: WHERE rt33.transaction_id = c_rec.transaction_id
1307: AND rt33.po_line_location_id = poll3.line_location_id

Line 2350: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;

2346: l_inv_count number;
2347: l_header cst_rcv_acq_costs.header_id%TYPE;
2348: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2349: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2350: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2351: l_po_price po_lines_all.unit_price%TYPE;
2352: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2353: l_po_line_loc po_lines_all.po_line_id%TYPE;
2354: l_item_id mtl_system_items.inventory_item_id%TYPE;

Line 2351: l_po_price po_lines_all.unit_price%TYPE;

2347: l_header cst_rcv_acq_costs.header_id%TYPE;
2348: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2349: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2350: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2351: l_po_price po_lines_all.unit_price%TYPE;
2352: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2353: l_po_line_loc po_lines_all.po_line_id%TYPE;
2354: l_item_id mtl_system_items.inventory_item_id%TYPE;
2355: l_org_id rcv_transactions.organization_id%TYPE;

Line 2353: l_po_line_loc po_lines_all.po_line_id%TYPE;

2349: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2350: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2351: l_po_price po_lines_all.unit_price%TYPE;
2352: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2353: l_po_line_loc po_lines_all.po_line_id%TYPE;
2354: l_item_id mtl_system_items.inventory_item_id%TYPE;
2355: l_org_id rcv_transactions.organization_id%TYPE;
2356: l_poll_quantity po_line_locations_all.quantity%TYPE;
2357: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;

Line 2463: po_lines_all POL,

2459: Into l_accounting_event_id,
2460: l_rae_unit_price,
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

Line 2517: po_lines_all pol1,

2513:
2514: SELECT count(rt2.transaction_id)
2515: INTO l_po_count
2516: FROM rcv_transactions rt2,
2517: po_lines_all pol1,
2518: po_line_locations_all poll1
2519: WHERE rt2.transaction_id = l_rec_transaction_id
2520: AND rt2.po_line_location_id = poll1.line_location_id
2521: AND pol1.po_line_id = poll1.po_line_id

Line 2596: po_lines_all pol2,

2592: l_org_id,
2593: l_rate,
2594: l_order_type_lookup_code
2595: FROM
2596: po_lines_all pol2,
2597: po_line_locations_all poll3,
2598: rcv_transactions rt33
2599: WHERE
2600: rt33.transaction_id = l_rec_transaction_id

Line 2786: PO_LINES_ALL POL,

2782: FROM
2783: ap_invoice_distributions_all ad2,
2784: -- J Changes -----------------------------------------------------------
2785: RCV_TRANSACTIONS RT,
2786: PO_LINES_ALL POL,
2787: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
2788: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
2789: ------------------------------------------------------------------------
2790: WHERE

Line 3233: FROM PO_LINES_ALL POL,

3229: l_stmt_num := 10;
3230:
3231: SELECT NVL(POLL.MATCHING_BASIS, POL.MATCHING_BASIS) -- Changed for Complex work Procurement
3232: INTO L_PO_LINE_TYPE_CODE
3233: FROM PO_LINES_ALL POL,
3234: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
3235: RCV_TRANSACTIONS RT
3236: WHERE POL.PO_LINE_ID = RT.PO_LINE_ID
3237: AND POLL.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID-- Added for Complex work Procurement

Line 5001: po_lines_all POL,

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

Line 5085: po_lines_all pol,

5081: nvl(rt.currency_conversion_rate,1)
5082: INTO
5083: l_rcv_rate
5084: FROM
5085: po_lines_all pol,
5086: po_line_locations_all poll,
5087: rcv_transactions rt
5088: WHERE
5089: rt.transaction_id = i_rcv_txn_id

Line 5146: po_lines_all POL,

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