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.RCV_TRANSACTIONS_INTERFACE_SV dependencies on PO_LINE_LOCATIONS

Line 131: FROM po_line_locations pll,

127: '' ussgl_transaction_code,
128: pll.ship_to_location_id,
129: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
130: pl.item_id
131: FROM po_line_locations pll,
132: po_lines pl,
133: po_headers ph
134: WHERE ph.po_header_id = header_id
135: AND pll.po_header_id = header_id

Line 164: FROM po_line_locations pll,

160: v_ship_to_location_id NUMBER,
161: v_vendor_product_num VARCHAR2
162: ) IS
163: SELECT COUNT(*)
164: FROM po_line_locations pll,
165: po_lines pl,
166: po_headers ph
167: WHERE ph.po_header_id = header_id
168: AND pll.po_header_id = header_id

Line 187: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select

183: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'));
184:
185: /***** Bug # 1553154
186: ***** There was a performance issue since the cursor COUNT_DISTRIBUTIONS
187: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select
188: ***** statement so that it will drive through PO_HEADERS_ALL
189: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL
190: ***** so that there is an improvement in performance.
191: *****/

Line 189: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL

185: /***** Bug # 1553154
186: ***** There was a performance issue since the cursor COUNT_DISTRIBUTIONS
187: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select
188: ***** statement so that it will drive through PO_HEADERS_ALL
189: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL
190: ***** so that there is an improvement in performance.
191: *****/
192: CURSOR distributions(
193: header_id NUMBER,

Line 243: po_line_locations pll,

239: pll.ship_to_location_id,
240: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
241: pl.item_id
242: FROM po_distributions pod,
243: po_line_locations pll,
244: po_lines pl,
245: po_headers ph
246: WHERE ph.po_header_id = header_id
247: AND pl.po_header_id = ph.po_header_id

Line 272: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by

268: ***** There was a performance issue since the cursor DISTRIBUTIONS
269: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
270: ***** Modified the Select statement so that it will drive through
271: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
272: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
273: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
274: ***** Performance
275: *****/
276: CURSOR count_distributions(

Line 289: po_line_locations pll,

285: v_vendor_product_num VARCHAR2
286: ) IS
287: SELECT COUNT(*)
288: FROM po_distributions pod,
289: po_line_locations pll,
290: po_lines pl,
291: po_headers ph
292: WHERE ph.po_header_id = header_id
293: AND pl.po_header_id = ph.po_header_id

Line 334: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%TYPE;

330: x_first_trans BOOLEAN := TRUE;
331: x_sysdate DATE := SYSDATE;
332: current_n BINARY_INTEGER := 0;
333: insert_into_table BOOLEAN := FALSE;
334: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%TYPE;
335: tax_amount_factor NUMBER;
336: lastrecord BOOLEAN := FALSE;
337: po_asn_uom_qty NUMBER;
338: po_primary_uom_qty NUMBER;

Line 1240: FROM po_line_locations

1236: AND temp_cascaded_table(current_n).po_line_location_id IS NOT NULL THEN
1237: BEGIN
1238: SELECT shipment_num
1239: INTO temp_cascaded_table(current_n).document_shipment_line_num
1240: FROM po_line_locations
1241: WHERE line_location_id = temp_cascaded_table(current_n).po_line_location_id;
1242: EXCEPTION
1243: WHEN OTHERS THEN
1244: IF (g_asn_debug = 'Y') THEN

Line 1274: po_line_locations and assigning the proper ship_location_id into a

1270: Enter error message in po_interface_errors if the enforcement is "Warning"
1271: Enter error message in po_interface_errors if the enforcement is "Reject"
1272: and error out.
1273: This validation is done by comparing the enforce_ship_location_code from
1274: po_line_locations and assigning the proper ship_location_id into a
1275: temporary variable temp_mirror_ship_to_loc_id and passing the temp
1276: variable as a parameter to open the cursor "Distributions".
1277: */
1278:

Line 1511: SELECT NVL(po_line_locations.qty_rcv_exception_code, 'NONE')

1507:
1508: IF rows_fetched > 0
1509: AND NOT x_first_trans THEN -- we had got atleast some rows from our shipments cursor
1510: -- we have atleast one row cascaded (not null line_location_id)
1511: SELECT NVL(po_line_locations.qty_rcv_exception_code, 'NONE')
1512: INTO x_qty_rcv_exception_code
1513: FROM po_line_locations
1514: WHERE line_location_id = temp_cascaded_table(current_n).po_line_location_id;
1515:

Line 1513: FROM po_line_locations

1509: AND NOT x_first_trans THEN -- we had got atleast some rows from our shipments cursor
1510: -- we have atleast one row cascaded (not null line_location_id)
1511: SELECT NVL(po_line_locations.qty_rcv_exception_code, 'NONE')
1512: INTO x_qty_rcv_exception_code
1513: FROM po_line_locations
1514: WHERE line_location_id = temp_cascaded_table(current_n).po_line_location_id;
1515:
1516: IF (g_asn_debug = 'Y') THEN
1517: asn_debug.put_line('Qty tolerance exception code ' || NVL(x_qty_rcv_exception_code, 'NONE1'));

Line 1647: FROM po_line_locations pll,

1643: AND NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') <> 'DELIVER') THEN
1644: -- Bug 2551443 Removed po_distributions from the FROM clause
1645: SELECT COUNT(*)
1646: INTO x_temp_count
1647: FROM po_line_locations pll,
1648: po_lines pl,
1649: po_headers ph
1650: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
1651: AND pll.po_header_id = ph.po_header_id

Line 1679: FROM po_line_locations pll,

1675: x_shipment_type,
1676: x_ship_to_organization_id,
1677: x_ship_to_location_id,
1678: x_vendor_product_num
1679: FROM po_line_locations pll,
1680: po_lines pl,
1681: po_headers ph
1682: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
1683: AND pll.po_header_id = ph.po_header_id

Line 1694: po_line_locations pll,

1690: OR NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
1691: SELECT COUNT(*)
1692: INTO x_temp_count
1693: FROM po_distributions pod,
1694: po_line_locations pll,
1695: po_lines pl,
1696: po_headers ph
1697: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
1698: AND pll.po_header_id = ph.po_header_id

Line 1729: po_line_locations pll,

1725: x_ship_to_organization_id,
1726: x_ship_to_location_id,
1727: x_vendor_product_num
1728: FROM po_distributions pod,
1729: po_line_locations pll,
1730: po_lines pl,
1731: po_headers ph
1732: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
1733: AND pll.po_header_id = ph.po_header_id

Line 2559: FROM po_line_locations pll,

2555: pll.ship_to_organization_id,
2556: pll.shipment_num,
2557: pll.receiving_routing_id,
2558: pll.country_of_origin_code
2559: FROM po_line_locations pll,
2560: po_lines pl,
2561: po_headers ph
2562: WHERE ph.po_header_id = pl.po_header_id
2563: AND pl.po_line_id = pll.po_line_id

Line 3381: FROM po_line_locations pll

3377: /* Added the check on po shipments allow_substitute_receipt flag - Bug 3009663. */
3378: BEGIN
3379: SELECT NVL(pll.allow_substitute_receipts_flag, 'N')
3380: INTO x_allow_substitute_receipts
3381: FROM po_line_locations pll
3382: WHERE pll.line_location_id = x_cascaded_table(n).po_line_location_id;
3383: EXCEPTION
3384: WHEN OTHERS THEN
3385: IF (g_asn_debug = 'Y') THEN