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.WIP_OSP dependencies on PO_HEADERS_ALL

Line 980: PO_HEADERS_ALL PH,

976:
977: CURSOR disc_check_po_req_cur IS
978: SELECT 'PO/REQ Linked'
979: FROM PO_RELEASES_ALL PR,
980: PO_HEADERS_ALL PH,
981: PO_DISTRIBUTIONS_ALL PD,
982: PO_LINE_LOCATIONS_ALL PLL /* Added as part of Bug2308832 */ /* Fixed bug 3115844 */
983: WHERE pd.po_line_id IS NOT NULL
984: AND pd.line_location_id IS NOT NULL

Line 1025: PO_HEADERS_ALL PH,

1021:
1022: CURSOR rep_check_po_req_cur IS
1023: SELECT 'PO/REQ Linked'
1024: FROM PO_RELEASES_ALL PR,
1025: PO_HEADERS_ALL PH,
1026: PO_DISTRIBUTIONS_ALL PD,
1027: PO_LINE_LOCATIONS_ALL PLL
1028: /* Fixed bug 3115844 */
1029: WHERE pd.po_line_id IS NOT NULL

Line 1441: po_headers_all ph,

1437: pd.wip_operation_seq_num wip_op_seq,
1438: pl.item_id item_id,
1439: pd.org_id ou_id -- operating unit
1440: FROM po_distributions_all pd,
1441: po_headers_all ph,
1442: po_lines_all pl,
1443: po_line_locations_all pll,
1444: po_line_types plt
1445: WHERE ph.type_lookup_code = 'STANDARD'

Line 1473: po_headers_all ph,

1469: pd.wip_operation_seq_num wip_op_seq,
1470: pl.item_id item_id,
1471: pd.org_id ou_id -- operating unit
1472: FROM po_distributions_all pd,
1473: po_headers_all ph,
1474: po_lines_all pl,
1475: po_line_locations_all pll,
1476: po_releases_all pr,
1477: po_line_types plt

Line 1829: po_headers_all ph,

1825: CURSOR c_multiple_po IS
1826: SELECT count(*)
1827: FROM po_distributions_all pd,
1828: po_lines_all pl,
1829: po_headers_all ph,
1830: po_releases_all pr,
1831: po_line_locations_all pll,
1832: wip_discrete_jobs wdj, -- bugfix 5000087
1833: wip_repetitive_schedules wrs, -- bugfix 5000087

Line 1954: po_headers_all ph,

1950: msi.primary_uom_code uom_code,
1951: pd.org_id ou_id -- operating unit
1952: FROM mtl_system_items msi,
1953: po_distributions_all pd,
1954: po_headers_all ph,
1955: po_lines_all pl,
1956: po_line_locations_all pll,
1957: wip_operation_resources wor,
1958: wip_operations wo,

Line 2030: po_headers_all ph,

2026: msi.primary_uom_code uom_code,
2027: pd.org_id ou_id -- operating unit
2028: FROM mtl_system_items msi,
2029: po_distributions_all pd,
2030: po_headers_all ph,
2031: po_lines_all pl,
2032: po_line_locations_all pll,
2033: po_releases_all pr,
2034: wip_operation_resources wor,

Line 2439: po_headers_all ph,

2435: 'PO' document_type,
2436: ph.type_lookup_code document_subtype,
2437: pd.org_id ou_id -- operating unit
2438: FROM po_distributions_all pd,
2439: po_headers_all ph,
2440: po_line_locations_all pll
2441: /* Fixed bug 3115844 */
2442: WHERE pd.po_line_id IS NOT NULL
2443: AND pd.line_location_id IS NOT NULL

Line 2467: po_headers_all ph,

2463: 'RELEASE' document_type,
2464: ph.type_lookup_code document_subtype,
2465: pd.org_id ou_id -- operating unit
2466: FROM po_distributions_all pd,
2467: po_headers_all ph,
2468: po_line_locations_all pll,
2469: po_releases_all pr
2470: /* Fixed bug 3115844 */
2471: WHERE pd.po_line_id IS NOT NULL

Line 2691: PO_HEADERS_ALL PH,

2687: FROM DUAL
2688: WHERE NOT EXISTS
2689: (SELECT '1'
2690: FROM PO_RELEASES_ALL PR,
2691: PO_HEADERS_ALL PH,
2692: PO_DISTRIBUTIONS_ALL PD
2693: WHERE PD.WIP_ENTITY_ID = p_wip_entity_id
2694: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id
2695: AND (p_op_seq_num is NULL

Line 2720: PO_HEADERS_ALL PH,

2716: FROM DUAL
2717: WHERE NOT EXISTS
2718: (SELECT '1'
2719: FROM PO_RELEASES_ALL PR,
2720: PO_HEADERS_ALL PH,
2721: PO_DISTRIBUTIONS_ALL PD
2722: WHERE PD.WIP_ENTITY_ID = p_wip_entity_id
2723: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id
2724: AND PD.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id