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

66: AND rct.organization_id = x_organization_id
67: AND poh.po_header_id = rct.po_header_id
68: AND rct.shipment_line_id = rsl.shipment_line_id
69: AND EXISTS (select '1'
70: from po_asl_attributes_val_v paa,
71: po_asl_documents pad
72: WHERE paa.vendor_id = x_vendor_id
73: AND paa.vendor_site_id = x_vendor_site_id
74: AND paa.item_id = x_item_id

Line 77: FROM po_asl_attributes_val_v paa2

73: AND paa.vendor_site_id = x_vendor_site_id
74: AND paa.item_id = x_item_id
75: AND paa.using_organization_id =
76: (SELECT MAX(paa2.using_organization_id)
77: FROM po_asl_attributes_val_v paa2
78: WHERE decode(paa2.using_organization_id, -1,
79: x_organization_id,
80: paa2.using_organization_id) =
81: x_organization_id

Line 217: from po_asl_attributes_val_v paa,

213: ** the correct value for transaction_id is retrived from receiving tables
214: ** only for which the ASL entries exists.
215: */
216: /* AND EXISTS (select '1'
217: from po_asl_attributes_val_v paa,
218: po_asl_documents pad
219: WHERE paa.vendor_id = x_vendor_id
220: AND paa.vendor_site_id = x_vendor_site_id
221: AND paa.item_id = x_item_id

Line 224: FROM po_asl_attributes_val_v paa2

220: AND paa.vendor_site_id = x_vendor_site_id
221: AND paa.item_id = x_item_id
222: AND paa.using_organization_id =
223: (SELECT MAX(paa2.using_organization_id)
224: FROM po_asl_attributes_val_v paa2
225: WHERE decode(paa2.using_organization_id, -1,
226: x_organization_id,
227: paa2.using_organization_id) =
228: x_organization_id