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.PO_VMI_ENABLED dependencies on PO_APPROVED_SUPPLIER_LIST

Line 58: po_approved_supplier_list pasl,

54: SELECT 'Y' into v_temp from dual
55: WHERE exists
56: (SELECT 1 from
57: po_asl_attributes paa,
58: po_approved_supplier_list pasl,
59: po_asl_status_rules pasr --bug 3648705 join to table not view
60: WHERE
61: paa.using_organization_id = p_organization_id
62: AND pasl.asl_id = paa.asl_id

Line 93: po_approved_supplier_list pasl,

89: from
90: po_vendors pv,
91: po_vendor_sites_all pvsa,
92: po_asl_attributes paa,
93: po_approved_supplier_list pasl,
94: po_asl_status_rules pasr --bug 3648672, join to base table instead of view
95: where
96: --Getting all organizations associated with the particular set_of_books_id
97: pv.set_of_books_id = l_sob_id -- bug 3648672

Line 103: --Getting to the po_approved_supplier_list using vendor_id and vendor_site_id

99: --Getting the vendor_id,vendor_site_id
100: AND pvsa.vendor_id = pv.vendor_id
101:
102:
103: --Getting to the po_approved_supplier_list using vendor_id and vendor_site_id
104: AND pvsa.vendor_id = pasl.vendor_id
105: AND pvsa.vendor_site_id = pasl.vendor_site_id
106: AND (pasl.disable_flag = 'N' OR pasl.disable_flag IS NULL)
107: and paa.asl_id = pasl.asl_id