eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPPACQ dependencies on PO_LINE_LOCATIONS_ALL

Line 57: po_line_locations_all poll, -- Added for Complex work Procurement

53: distinct rt.transaction_id ,
54: nvl(poll.lcm_flag,'N') lcm_flag
55: FROM
56: rcv_transactions rt,
57: po_line_locations_all poll, -- Added for Complex work Procurement
58: cst_cost_group_assignments ccga1
59: WHERE rt.transaction_date BETWEEN i_start_date and i_end_date AND
60: -- Added for Complex work Procurement
61: rt.po_line_id = poll.po_line_id AND

Line 166: po_line_locations_all poll, -- Added for Complex work Procurement

162: AND aida2.org_id = aida.org_id /* rgangara perf bug 7475729 */
163: AND aida2.line_type_lookup_code <> 'REC_TAX'
164: AND aida.rcv_transaction_id is not null
165: AND EXISTS (select 1 from rcv_transactions rt,
166: po_line_locations_all poll, -- Added for Complex work Procurement
167: cst_cost_group_assignments ccga
168: where rt.transaction_id = aida.rcv_transaction_id
169: -- Added for Complex work Procurement
170: and rt.po_line_id = poll.po_line_id

Line 215: po_line_locations_all poll, -- Added for Complex work Procurement

211: /* Invoice Lines Project, TAX is now REC_TAX and NONREC_TAX */
212: and aida.line_type_lookup_code <> 'REC_TAX'
213: and aida.rcv_transaction_id is NOT NULL
214: and exists (select 1 from rcv_transactions rt,
215: po_line_locations_all poll, -- Added for Complex work Procurement
216: cst_cost_group_assignments ccga
217: where rt.transaction_id = aida.rcv_transaction_id
218: -- Added for Complex work Procurement
219: and rt.po_line_id = poll.po_line_id -- bug 9928504 fix

Line 282: po_line_locations_all poll,

278: mtl_parameters mp,
279: rcv_transactions rt,
280: rcv_parameters rp,
281: mtl_system_items msi,
282: po_line_locations_all poll,
283: mtl_units_of_measure muom
284: WHERE rt.transaction_date < l_start_date
285: AND clat.transaction_date BETWEEN l_start_date and l_end_date
286: AND clat.rcv_transaction_id = rt.transaction_id

Line 563: l_poll_quantity po_line_locations_all.quantity%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;
565: l_po_count NUMBER; -- remove this later
566: l_nr_tax_rate NUMBER;
567: l_match_option po_line_locations_all.match_option%TYPE;

Line 564: l_pri_poll_quantity po_line_locations_all.quantity%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;
565: l_po_count NUMBER; -- remove this later
566: l_nr_tax_rate NUMBER;
567: l_match_option po_line_locations_all.match_option%TYPE;
568: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;

Line 567: l_match_option po_line_locations_all.match_option%TYPE;

563: l_poll_quantity po_line_locations_all.quantity%TYPE;
564: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
565: l_po_count NUMBER; -- remove this later
566: l_nr_tax_rate NUMBER;
567: l_match_option po_line_locations_all.match_option%TYPE;
568: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
569: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
570:
571: BEGIN

Line 623: po_line_locations_all POLL, -- Added for Complex work Procurement

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
627: and rae.trx_flow_header_id is not null

Line 653: -- Get the match_option from po_line_locations_all

649: End if;
650: /* dropshipment end */
651:
652: -------------------------------------------------------------
653: -- Get the match_option from po_line_locations_all
654: -- If match_option is P then exch rate has to be the rate at the time of PO
655: -- If match_option is R then exch rate has to be the rate at the time of Receipt
656: -------------------------------------------------------------
657:

Line 662: FROM po_line_locations_all poll,

658: l_stmt_num := 130;
659:
660: SELECT nvl(poll.match_option,'P')
661: INTO l_match_option
662: FROM po_line_locations_all poll,
663: rcv_transactions rt7
664: WHERE
665: poll.line_location_id = rt7.po_line_location_id
666: AND rt7.transaction_id = c_rec.transaction_id;

Line 680: po_line_locations_all poll1

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
684: AND ROWNUM < 2;

Line 710: po_line_locations_all poll2

706: l_order_type_lookup_code
707: FROM
708: rcv_transactions rt3,
709: rcv_shipment_lines rsl,
710: po_line_locations_all poll2
711: WHERE
712: rt3.transaction_id = c_rec.transaction_id
713: AND rt3.po_line_location_id = poll2.line_location_id
714: AND rsl.shipment_line_id = rt3.shipment_line_id;

Line 759: po_line_locations_all poll3,

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
763: AND rt33.po_line_location_id = poll3.line_location_id

Line 953: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement

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
957: ad2.rcv_transaction_id = c_rec.transaction_id

Line 1216: l_po_line_loc po_line_locations_all.line_location_id%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;
1219: BEGIN
1220: l_stmt_num := 1000;

Line 1304: po_line_locations_all poll3,

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
1308: AND pol2.po_line_id = poll3.po_line_id;

Line 2356: l_poll_quantity po_line_locations_all.quantity%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;
2358: l_po_count NUMBER; -- remove this later
2359: l_nr_tax_rate NUMBER;
2360: l_match_option po_line_locations_all.match_option%TYPE;

Line 2357: l_pri_poll_quantity po_line_locations_all.quantity%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;
2358: l_po_count NUMBER; -- remove this later
2359: l_nr_tax_rate NUMBER;
2360: l_match_option po_line_locations_all.match_option%TYPE;
2361: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;

Line 2360: l_match_option po_line_locations_all.match_option%TYPE;

2356: l_poll_quantity po_line_locations_all.quantity%TYPE;
2357: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
2358: l_po_count NUMBER; -- remove this later
2359: l_nr_tax_rate NUMBER;
2360: l_match_option po_line_locations_all.match_option%TYPE;
2361: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
2362: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
2363:
2364: BEGIN

Line 2464: po_line_locations_all POLL, -- Added for Complex work Procurement

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
2468: And rae.trx_flow_header_id is not null

Line 2491: -- Get the match_option from po_line_locations_all

2487: End if;
2488: /* dropshipment end */
2489:
2490: -------------------------------------------------------------
2491: -- Get the match_option from po_line_locations_all
2492: -- If match_option is P then exch rate has to be the rate at the time of PO
2493: -- If match_option is R then exch rate has to be the rate at the time of Receipt
2494: -------------------------------------------------------------
2495:

Line 2500: FROM po_line_locations_all poll,

2496: l_stmt_num := 131;
2497:
2498: SELECT nvl(poll.match_option,'P')
2499: INTO l_match_option
2500: FROM po_line_locations_all poll,
2501: rcv_transactions rt7
2502: WHERE
2503: poll.line_location_id = rt7.po_line_location_id
2504: AND rt7.transaction_id = l_rec_transaction_id;

Line 2518: po_line_locations_all poll1

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
2522: AND ROWNUM < 2;

Line 2548: po_line_locations_all poll2

2544: l_order_type_lookup_code
2545: FROM
2546: rcv_transactions rt3,
2547: rcv_shipment_lines rsl,
2548: po_line_locations_all poll2
2549: WHERE
2550: rt3.transaction_id = l_rec_transaction_id
2551: AND rt3.po_line_location_id = poll2.line_location_id
2552: AND rsl.shipment_line_id = rt3.shipment_line_id;

Line 2597: po_line_locations_all poll3,

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
2601: AND rt33.po_line_location_id = poll3.line_location_id

Line 2787: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement

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
2791: ad2.rcv_transaction_id = l_rec_transaction_id

Line 3234: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement

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
3238: AND RT.TRANSACTION_ID = I_TRANSACTION_ID;

Line 4769: po_line_locations_all poll

4765: l_par_txn,
4766: l_lcm_flag
4767: FROM
4768: rcv_transactions rt6,
4769: po_line_locations_all poll
4770: WHERE
4771: rt6.transaction_type in ('RECEIVE','MATCH')
4772: AND poll.line_location_id = rt6.po_line_location_id
4773: START WITH

Line 4932: po_line_locations_all pll

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
4935: AND PLL.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID
4936: AND (

Line 5086: po_line_locations_all poll,

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
5090: AND rt.po_line_location_id = poll.line_location_id

Line 5220: PO_LINE_LOCATIONS_ALL POLL

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
5223: AND (
5224: ( RT.PO_DISTRIBUTION_ID IS NOT NULL