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_SHP_I_WF dependencies on STANDARD

Line 564: and ph.type_lookup_code = 'STANDARD'

560: and pd.wip_operation_seq_num = l_osp_operation_num
561: and nvl(pd.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)
562: and pd.po_header_id = ph.po_header_id
563: --and ph.approved_flag = 'Y'
564: and ph.type_lookup_code = 'STANDARD'
565: and nvl(ph.cancel_flag, 'N') = 'N'
566: and pl.po_line_id = pd.po_line_id
567: and pl.po_header_id = pd.po_header_id
568: and pv.vendor_id = ph.vendor_id

Line 1425: and ( (ph2.type_lookup_code = 'STANDARD'

1421: and pla.location_id = ps1.ship_to_location_id
1422: and pla.vendor_id = ph2.vendor_id
1423: and pla.vendor_site_id = ph2.vendor_site_id
1424: and pr.po_release_id (+) = pd2.po_release_id
1425: and ( (ph2.type_lookup_code = 'STANDARD'
1426: and nvl(ph2.cancel_flag, 'N') = 'N')
1427: OR (ph2.type_lookup_code = 'BLANKET'
1428: and pr.po_release_id = pd2.po_release_id
1429: and nvl(pr.cancel_flag, 'N') = 'N'))