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.CHV_CUM_PERIODS_S1 dependencies on PO_ASL_ATTRIBUTES_VAL_V

Line 103: from po_asl_attributes_val_v paa,

99: ** the correct value for transaction_id is retrived from receiving tables
100: ** only for which the ASL entries exists.
101: */
102: AND EXISTS (select '1'
103: from po_asl_attributes_val_v paa,
104: po_asl_documents pad
105: WHERE paa.vendor_id = x_vendor_id
106: AND paa.vendor_site_id = x_vendor_site_id
107: AND paa.item_id = x_item_id

Line 110: FROM po_asl_attributes_val_v paa2

106: AND paa.vendor_site_id = x_vendor_site_id
107: AND paa.item_id = x_item_id
108: AND paa.using_organization_id =
109: (SELECT MAX(paa2.using_organization_id)
110: FROM po_asl_attributes_val_v paa2
111: WHERE decode(paa2.using_organization_id, -1,
112: x_organization_id,
113: paa2.using_organization_id) =
114: x_organization_id

Line 170: from po_asl_attributes_val_v paa,

166: ** the correct value for transaction_id is retrived from receiving tables
167: ** only for which the ASL entries exists.
168: */
169: AND EXISTS (select '1'
170: from po_asl_attributes_val_v paa,
171: po_asl_documents pad
172: WHERE paa.vendor_id = x_vendor_id
173: AND paa.vendor_site_id = x_vendor_site_id
174: AND paa.item_id = x_item_id

Line 177: FROM po_asl_attributes_val_v paa2

173: AND paa.vendor_site_id = x_vendor_site_id
174: AND paa.item_id = x_item_id
175: AND paa.using_organization_id =
176: (SELECT MAX(paa2.using_organization_id)
177: FROM po_asl_attributes_val_v paa2
178: WHERE decode(paa2.using_organization_id, -1,
179: x_organization_id,
180: paa2.using_organization_id) =
181: x_organization_id