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.POS_SUPPLIER_PUB_JOB_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 77: FROM ap_supplier_sites_all aps,

73: WHERE hz.party_id = ap.party_id
74: AND hz.last_update_date BETWEEN l_from_date AND l_to_date
75: UNION
76: SELECT ap.party_id
77: FROM ap_supplier_sites_all aps,
78: ap_suppliers ap
79: WHERE aps.vendor_id = ap.vendor_id
80: AND aps.last_update_date BETWEEN l_from_date AND l_to_date
81: UNION

Line 85: ap_supplier_sites_all ss

81: UNION
82: SELECT ap.party_id
83: FROM hz_locations hz,
84: ap_suppliers ap,
85: ap_supplier_sites_all ss
86: WHERE ss.vendor_id = ap.vendor_id
87: AND hz.location_id = ss.location_id
88: AND hz.last_update_date BETWEEN l_from_date AND l_to_date
89: UNION

Line 119: ap_supplier_sites_all sa

115: UNION
116: SELECT ap.party_id
117: FROM ap_supplier_contacts apsc,
118: ap_suppliers ap,
119: ap_supplier_sites_all sa
120: WHERE sa.vendor_id = ap.vendor_id
121: AND apsc.vendor_site_id = sa.vendor_site_id
122: AND apsc.last_update_date BETWEEN l_from_date AND l_to_date
123: UNION