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_LINES

Line 132: po_lines pl,

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
136: AND pl.line_num = NVL(v_po_line_num, pl.line_num)

Line 165: po_lines pl,

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
169: AND pl.line_num = NVL(v_po_line_num, pl.line_num)

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 244: po_lines pl,

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
248: AND pll.po_line_id = pl.po_line_id

Line 271: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by

267: /***** Bug # 1553154
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: *****/

Line 290: po_lines pl,

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
294: AND pll.po_line_id = pl.po_line_id

Line 1225: FROM po_lines

1221: AND temp_cascaded_table(current_n).po_line_id IS NOT NULL THEN
1222: BEGIN
1223: SELECT line_num
1224: INTO temp_cascaded_table(current_n).document_line_num
1225: FROM po_lines
1226: WHERE po_line_id = temp_cascaded_table(current_n).po_line_id;
1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: IF (g_asn_debug = 'Y') THEN

Line 1648: po_lines pl,

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
1652: AND pl.line_num = NVL(temp_cascaded_table(current_n).document_line_num, pl.line_num)

Line 1680: po_lines pl,

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
1684: AND pl.line_num = NVL(temp_cascaded_table(current_n).document_line_num, pl.line_num)

Line 1695: po_lines pl,

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
1699: AND pll.line_location_id = pod.line_location_id

Line 1730: po_lines pl,

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
1734: AND pll.line_location_id = pod.line_location_id

Line 2560: po_lines pl,

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
2564: AND ph.po_header_id = v_header_id

Line 4019: if revision is null then try to pick up item_revision from po_lines

4015: AND organization_id = x_item_revision_record.to_organization_id;
4016:
4017: /* If item is under revision control
4018:
4019: if revision is null then try to pick up item_revision from po_lines
4020:
4021: if revision is still null and
4022: there are any destination_type=INVENTORY then
4023:

Line 4041: FROM po_lines

4037: END IF;
4038:
4039: SELECT item_revision
4040: INTO x_item_revision_record.item_revision
4041: FROM po_lines
4042: WHERE po_lines.po_line_id = x_item_revision_record.po_line_id;
4043: END IF;
4044:
4045: IF x_item_revision_record.item_revision IS NULL THEN -- see whether any destination_type = 'INVENTORY'

Line 4042: WHERE po_lines.po_line_id = x_item_revision_record.po_line_id;

4038:
4039: SELECT item_revision
4040: INTO x_item_revision_record.item_revision
4041: FROM po_lines
4042: WHERE po_lines.po_line_id = x_item_revision_record.po_line_id;
4043: END IF;
4044:
4045: IF x_item_revision_record.item_revision IS NULL THEN -- see whether any destination_type = 'INVENTORY'
4046: SELECT COUNT(*)

Line 4405: FROM po_lines

4401: SELECT po_line_id,
4402: item_id
4403: INTO x_po_line_id_record.po_line_id,
4404: x_po_line_id_record.item_id
4405: FROM po_lines
4406: WHERE po_header_id = x_po_line_id_record.po_header_id
4407: AND line_num = x_po_line_id_record.document_line_num;
4408:
4409: IF (x_po_line_id_record.po_line_id IS NULL) THEN