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_HEADERS

Line 133: po_headers ph

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)
137: AND NVL(pll.po_release_id, 0) = NVL(v_po_release_id, NVL(pll.po_release_id, 0))

Line 166: po_headers ph

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)
170: AND NVL(pll.po_release_id, 0) = NVL(v_po_release_id, NVL(pll.po_release_id, 0))

Line 188: ***** statement so that it will drive through PO_HEADERS_ALL

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: *****/
192: CURSOR distributions(

Line 245: po_headers ph

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

Line 269: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL

265: ORDER BY NVL(pll.promised_date, pll.need_by_date);
266:
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

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 291: po_headers ph

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

Line 1649: po_headers ph

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)
1653: AND NVL(pll.po_release_id, 0) = NVL(temp_cascaded_table(current_n).po_release_id, NVL(pll.po_release_id, 0))

Line 1681: po_headers ph

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)
1685: AND NVL(pll.po_release_id, 0) = NVL(temp_cascaded_table(current_n).po_release_id, NVL(pll.po_release_id, 0))

Line 1696: po_headers ph

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

Line 1731: po_headers ph

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

Line 2355: --Bug#2708861.Added the following so that rate_type gets defaulted from po_headers.

2351: IF (temp_cascaded_table(current_n).currency_conversion_rate IS NULL) THEN
2352: temp_cascaded_table(current_n).currency_conversion_rate := x_shipmentdistributionrec.rate;
2353: END IF;
2354:
2355: --Bug#2708861.Added the following so that rate_type gets defaulted from po_headers.
2356: IF (temp_cascaded_table(current_n).currency_conversion_type IS NULL) THEN
2357: temp_cascaded_table(current_n).currency_conversion_type := x_shipmentdistributionrec.rate_type;
2358: END IF;
2359:

Line 2561: po_headers ph

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
2565: AND pl.po_line_id = v_line_id

Line 2698: FROM po_headers

2694: IF x_cascaded_table(n).vendor_site_id IS NULL
2695: AND x_cascaded_table(n).vendor_site_code IS NULL THEN
2696: SELECT vendor_site_id
2697: INTO x_vendor_site_id
2698: FROM po_headers
2699: WHERE po_header_id = x_cascaded_table(n).po_header_id
2700: AND vendor_id = x_cascaded_table(n).vendor_id;
2701:
2702: SELECT vendor_site_code

Line 4286: /* type_lookup_code will never be SCHEDULED in po_headers. This

4282: PROCEDURE get_po_header_id(
4283: x_po_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type
4284: ) IS
4285: BEGIN
4286: /* type_lookup_code will never be SCHEDULED in po_headers. This
4287: * should be PLANNED. Because of this, for PLANNED POs get_po_header_id
4288: * used to fail and hence open interface used to fail.
4289: * Changing SCHEDULED to PLANNED.
4290: */

Line 4293: FROM po_headers

4289: * Changing SCHEDULED to PLANNED.
4290: */
4291: SELECT MAX(po_header_id)
4292: INTO x_po_header_id_record.po_header_id
4293: FROM po_headers
4294: WHERE segment1 = x_po_header_id_record.document_num
4295: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED'); -- Could be a quotation with same number
4296:
4297: IF (x_po_header_id_record.po_header_id IS NULL) THEN