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 164: from po_asl_attributes_val_v paa,

160: ** the correct value for transaction_id is retrived from receiving tables
161: ** only for which the ASL entries exists.
162: */
163: AND EXISTS (select '1'
164: from po_asl_attributes_val_v paa,
165: po_asl_documents pad
166: WHERE paa.vendor_id = x_vendor_id
167: AND paa.vendor_site_id = x_vendor_site_id
168: AND paa.item_id = x_item_id

Line 171: FROM po_asl_attributes_val_v paa2

167: AND paa.vendor_site_id = x_vendor_site_id
168: AND paa.item_id = x_item_id
169: AND paa.using_organization_id =
170: (SELECT MAX(paa2.using_organization_id)
171: FROM po_asl_attributes_val_v paa2
172: WHERE decode(paa2.using_organization_id, -1,
173: x_organization_id,
174: paa2.using_organization_id) =
175: x_organization_id