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 111: po_line_locations_all poll, -- Added for Complex work Procurement

107: WHERE aida.rcv_transaction_id is not null
108: and i_invoice_no IS NULL
109: and i_receipt_no is NULL
110: and exists (select 1 from rcv_transactions rt,
111: po_line_locations_all poll, -- Added for Complex work Procurement
112: cst_cost_group_assignments ccga
113: where rt.transaction_id = aida.rcv_transaction_id
114: -- Added for Complex work Procurement
115: and rt.po_line_id = poll.po_line_id

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

166: and aida.rcv_transaction_id is NOT NULL
167: and i_receipt_no IS NULL
168: and i_invoice_no IS NULL
169: and exists (select 1 from rcv_transactions rt,
170: po_line_locations_all poll, -- Added for Complex work Procurement
171: cst_cost_group_assignments ccga
172: where rt.transaction_id = aida.rcv_transaction_id
173: -- Added for Complex work Procurement
174: and rt.po_line_id = poll.line_location_id

Line 222: po_line_locations_all poll

218: prior rt2.transaction_id = rt2.parent_transaction_id
219: )
220: AND EXISTS ( Select 'not lcm enabled'
221: FROM rcv_transactions rt,
222: po_line_locations_all poll
223: WHERE rt.transaction_id = i_receipt_no
224: AND rt.po_line_location_id = poll.line_location_id
225: AND nvl(poll.lcm_flag,'N') = 'N'
226:

Line 244: po_line_locations_all poll

240: AND rae.trx_flow_header_id is not NULL)
241: AND NOT EXISTS ( SELECT 1
242: FROM rcv_transactions rt,
243: po_distributions_all pod,
244: po_line_locations_all poll
245: WHERE rt.transaction_id = aida.rcv_transaction_id
246: AND pod.line_location_id = rt.po_line_location_id
247: AND poll.line_location_id = rt.po_line_location_id
248: AND nvl(poll.lcm_flag,'N') = 'Y'

Line 288: po_line_locations_all poll,

284: mtl_parameters mp,
285: rcv_transactions rt,
286: rcv_parameters rp,
287: mtl_system_items msi,
288: po_line_locations_all poll,
289: mtl_units_of_measure muom
290: WHERE rt.transaction_date < l_start_date
291: AND clat.transaction_date BETWEEN l_start_date and l_end_date
292: 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 650: -- Get the match_option from po_line_locations_all

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

Line 659: FROM po_line_locations_all poll,

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

Line 677: po_line_locations_all poll1

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

Line 707: po_line_locations_all poll2

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

Line 756: po_line_locations_all poll3,

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

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

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

Line 1211: l_po_line_loc po_line_locations_all.line_location_id%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;
1214: BEGIN
1215: l_stmt_num := 1000;

Line 1299: po_line_locations_all poll3,

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

Line 2308: l_poll_quantity po_line_locations_all.quantity%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;
2310: l_po_count NUMBER; -- remove this later
2311: l_nr_tax_rate NUMBER;
2312: l_match_option po_line_locations_all.match_option%TYPE;

Line 2309: l_pri_poll_quantity po_line_locations_all.quantity%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;
2310: l_po_count NUMBER; -- remove this later
2311: l_nr_tax_rate NUMBER;
2312: l_match_option po_line_locations_all.match_option%TYPE;
2313: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;

Line 2312: l_match_option po_line_locations_all.match_option%TYPE;

2308: l_poll_quantity po_line_locations_all.quantity%TYPE;
2309: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
2310: l_po_count NUMBER; -- remove this later
2311: l_nr_tax_rate NUMBER;
2312: l_match_option po_line_locations_all.match_option%TYPE;
2313: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
2314: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
2315:
2316: BEGIN

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

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

Line 2443: -- Get the match_option from po_line_locations_all

2439: End if;
2440: /* dropshipment end */
2441:
2442: -------------------------------------------------------------
2443: -- Get the match_option from po_line_locations_all
2444: -- If match_option is P then exch rate has to be the rate at the time of PO
2445: -- If match_option is R then exch rate has to be the rate at the time of Receipt
2446: -------------------------------------------------------------
2447:

Line 2452: FROM po_line_locations_all poll,

2448: l_stmt_num := 131;
2449:
2450: SELECT nvl(poll.match_option,'P')
2451: INTO l_match_option
2452: FROM po_line_locations_all poll,
2453: rcv_transactions rt7
2454: WHERE
2455: poll.line_location_id = rt7.po_line_location_id
2456: AND rt7.transaction_id = c_rec.transaction_id;

Line 2470: po_line_locations_all poll1

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

Line 2500: po_line_locations_all poll2

2496: l_order_type_lookup_code
2497: FROM
2498: rcv_transactions rt3,
2499: rcv_shipment_lines rsl,
2500: po_line_locations_all poll2
2501: WHERE
2502: rt3.transaction_id = c_rec.transaction_id
2503: AND rt3.po_line_location_id = poll2.line_location_id
2504: AND rsl.shipment_line_id = rt3.shipment_line_id;

Line 2549: po_line_locations_all poll3,

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

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

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

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

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

Line 4624: po_line_locations_all poll

4620: l_par_txn,
4621: l_lcm_flag
4622: FROM
4623: rcv_transactions rt6,
4624: po_line_locations_all poll
4625: WHERE
4626: rt6.transaction_type in ('RECEIVE','MATCH')
4627: AND poll.line_location_id = rt6.po_line_location_id
4628: START WITH

Line 4787: po_line_locations_all pll

4783: l_tot_tax
4784: FROM
4785: po_distributions_all pod,
4786: rcv_transactions rcv,
4787: po_line_locations_all pll
4788: WHERE RCV.TRANSACTION_ID = i_rcv_txn_id
4789: AND POD.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID
4790: AND PLL.LINE_LOCATION_ID = RCV.PO_LINE_LOCATION_ID
4791: AND (

Line 4908: PO_LINE_LOCATIONS_ALL POLL

4904: l_po_rate
4905: FROM
4906: PO_DISTRIBUTIONS_ALL POD,
4907: RCV_TRANSACTIONS RT,
4908: PO_LINE_LOCATIONS_ALL POLL
4909: WHERE
4910: RT.TRANSACTION_ID = i_rcv_txn_id
4911: AND (
4912: ( RT.PO_DISTRIBUTION_ID IS NOT NULL