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 905: PO_HEADERS_ALL PH,

901:
902: CURSOR disc_check_po_req_cur IS
903: SELECT 'PO/REQ Linked'
904: FROM PO_RELEASES_ALL PR,
905: PO_HEADERS_ALL PH,
906: PO_DISTRIBUTIONS_ALL PD,
907: PO_LINE_LOCATIONS_ALL PLL /* Added as part of Bug2308832 */ /* Fixed bug 3115844 */
908: WHERE pd.po_line_id IS NOT NULL
909: AND pd.line_location_id IS NOT NULL

Line 949: PO_HEADERS_ALL PH,

945:
946: CURSOR rep_check_po_req_cur IS
947: SELECT 'PO/REQ Linked'
948: FROM PO_RELEASES_ALL PR,
949: PO_HEADERS_ALL PH,
950: PO_DISTRIBUTIONS_ALL PD,
951: PO_LINE_LOCATIONS_ALL PLL
952: /* Fixed bug 3115844 */
953: WHERE pd.po_line_id IS NOT NULL

Line 1355: po_headers_all ph,

1351: pd.wip_operation_seq_num wip_op_seq,
1352: pl.item_id item_id,
1353: pd.org_id ou_id -- operating unit
1354: FROM po_distributions_all pd,
1355: po_headers_all ph,
1356: po_lines_all pl,
1357: po_line_locations_all pll,
1358: po_line_types plt
1359: WHERE ph.type_lookup_code = 'STANDARD'

Line 1387: po_headers_all ph,

1383: pd.wip_operation_seq_num wip_op_seq,
1384: pl.item_id item_id,
1385: pd.org_id ou_id -- operating unit
1386: FROM po_distributions_all pd,
1387: po_headers_all ph,
1388: po_lines_all pl,
1389: po_line_locations_all pll,
1390: po_releases_all pr,
1391: po_line_types plt

Line 1736: po_headers_all ph,

1732: CURSOR c_multiple_po IS
1733: SELECT count(*)
1734: FROM po_distributions_all pd,
1735: po_lines_all pl,
1736: po_headers_all ph,
1737: po_releases_all pr,
1738: po_line_locations_all pll,
1739: wip_discrete_jobs wdj, -- bugfix 5000087
1740: wip_repetitive_schedules wrs, -- bugfix 5000087

Line 1846: po_headers_all ph,

1842: msi.primary_uom_code uom_code,
1843: pd.org_id ou_id -- operating unit
1844: FROM mtl_system_items msi,
1845: po_distributions_all pd,
1846: po_headers_all ph,
1847: po_lines_all pl,
1848: po_line_locations_all pll,
1849: wip_operation_resources wor,
1850: wip_operations wo,

Line 1909: po_headers_all ph,

1905: msi.primary_uom_code uom_code,
1906: pd.org_id ou_id -- operating unit
1907: FROM mtl_system_items msi,
1908: po_distributions_all pd,
1909: po_headers_all ph,
1910: po_lines_all pl,
1911: po_line_locations_all pll,
1912: po_releases_all pr,
1913: wip_operation_resources wor,

Line 2278: po_headers_all ph,

2274: 'PO' document_type,
2275: ph.type_lookup_code document_subtype,
2276: pd.org_id ou_id -- operating unit
2277: FROM po_distributions_all pd,
2278: po_headers_all ph,
2279: po_line_locations_all pll
2280: /* Fixed bug 3115844 */
2281: WHERE pd.po_line_id IS NOT NULL
2282: AND pd.line_location_id IS NOT NULL

Line 2306: po_headers_all ph,

2302: 'RELEASE' document_type,
2303: ph.type_lookup_code document_subtype,
2304: pd.org_id ou_id -- operating unit
2305: FROM po_distributions_all pd,
2306: po_headers_all ph,
2307: po_line_locations_all pll,
2308: po_releases_all pr
2309: /* Fixed bug 3115844 */
2310: WHERE pd.po_line_id IS NOT NULL

Line 2529: PO_HEADERS_ALL PH,

2525: FROM DUAL
2526: WHERE NOT EXISTS
2527: (SELECT '1'
2528: FROM PO_RELEASES_ALL PR,
2529: PO_HEADERS_ALL PH,
2530: PO_DISTRIBUTIONS_ALL PD
2531: WHERE PD.WIP_ENTITY_ID = p_wip_entity_id
2532: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id
2533: AND (p_op_seq_num is NULL

Line 2558: PO_HEADERS_ALL PH,

2554: FROM DUAL
2555: WHERE NOT EXISTS
2556: (SELECT '1'
2557: FROM PO_RELEASES_ALL PR,
2558: PO_HEADERS_ALL PH,
2559: PO_DISTRIBUTIONS_ALL PD
2560: WHERE PD.WIP_ENTITY_ID = p_wip_entity_id
2561: AND PD.DESTINATION_ORGANIZATION_ID = p_organization_id
2562: AND PD.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id