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_S2 dependencies on PO_ASL_ATTRIBUTES_VAL_V

Line 76: from po_asl_attributes_val_v paa,

72: AND rct.organization_id = x_organization_id
73: AND poh.po_header_id = rct.po_header_id
74: AND rct.shipment_line_id = rsl.shipment_line_id
75: AND EXISTS (select '1'
76: from po_asl_attributes_val_v paa,
77: po_asl_documents pad
78: WHERE paa.vendor_id = x_vendor_id
79: AND paa.vendor_site_id = x_vendor_site_id
80: AND paa.item_id = x_item_id

Line 83: FROM po_asl_attributes_val_v paa2

79: AND paa.vendor_site_id = x_vendor_site_id
80: AND paa.item_id = x_item_id
81: AND paa.using_organization_id =
82: (SELECT MAX(paa2.using_organization_id)
83: FROM po_asl_attributes_val_v paa2
84: WHERE decode(paa2.using_organization_id, -1,
85: x_organization_id,
86: paa2.using_organization_id) =
87: x_organization_id

Line 223: from po_asl_attributes_val_v paa,

219: ** the correct value for transaction_id is retrived from receiving tables
220: ** only for which the ASL entries exists.
221: */
222: /* AND EXISTS (select '1'
223: from po_asl_attributes_val_v paa,
224: po_asl_documents pad
225: WHERE paa.vendor_id = x_vendor_id
226: AND paa.vendor_site_id = x_vendor_site_id
227: AND paa.item_id = x_item_id

Line 230: FROM po_asl_attributes_val_v paa2

226: AND paa.vendor_site_id = x_vendor_site_id
227: AND paa.item_id = x_item_id
228: AND paa.using_organization_id =
229: (SELECT MAX(paa2.using_organization_id)
230: FROM po_asl_attributes_val_v paa2
231: WHERE decode(paa2.using_organization_id, -1,
232: x_organization_id,
233: paa2.using_organization_id) =
234: x_organization_id