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 607: and ph.type_lookup_code = 'STANDARD'

603: and pd.wip_operation_seq_num = l_osp_operation_num
604: and nvl(pd.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)
605: and pd.po_header_id = ph.po_header_id
606: --and ph.approved_flag = 'Y'
607: and ph.type_lookup_code = 'STANDARD'
608: and nvl(ph.cancel_flag, 'N') = 'N'
609: and pl.po_line_id = pd.po_line_id
610: and pl.po_header_id = pd.po_header_id
611: and pv.vendor_id = ph.vendor_id

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

1464: and pla.location_id = ps1.ship_to_location_id
1465: and pla.vendor_id = ph2.vendor_id
1466: and pla.vendor_site_id = ph2.vendor_site_id
1467: and pr.po_release_id (+) = pd2.po_release_id
1468: and ( (ph2.type_lookup_code = 'STANDARD'
1469: and nvl(ph2.cancel_flag, 'N') = 'N')
1470: OR (ph2.type_lookup_code = 'BLANKET'
1471: and pr.po_release_id = pd2.po_release_id
1472: and nvl(pr.cancel_flag, 'N') = 'N'))