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.PO_AME_WF_PVT dependencies on PO_LINES_ALL

Line 3200: FROM po_lines_all

3196: (ad.pk1_value = (SELECT To_Char(vendor_id)
3197: FROM po_headers_all
3198: WHERE po_header_id = l_po_header_id) AND ad.entity_name = 'PO_VENDORS') OR
3199: (ad.pk1_value IN (SELECT To_Char(po_line_id)
3200: FROM po_lines_all
3201: WHERE po_header_id = l_po_header_id ) AND ad.entity_name = 'PO_LINES') OR
3202: (ad.pk1_value IN (SELECT To_Char(from_header_id)
3203: FROM po_lines_all
3204: WHERE po_header_id = l_po_header_id

Line 3203: FROM po_lines_all

3199: (ad.pk1_value IN (SELECT To_Char(po_line_id)
3200: FROM po_lines_all
3201: WHERE po_header_id = l_po_header_id ) AND ad.entity_name = 'PO_LINES') OR
3202: (ad.pk1_value IN (SELECT To_Char(from_header_id)
3203: FROM po_lines_all
3204: WHERE po_header_id = l_po_header_id
3205: AND from_header_id IS NOT NULL ) AND ad.entity_name = 'PO_HEADERS') OR
3206: (ad.pk1_value IN (SELECT To_Char(from_line_id)
3207: FROM po_lines_all

Line 3207: FROM po_lines_all

3203: FROM po_lines_all
3204: WHERE po_header_id = l_po_header_id
3205: AND from_header_id IS NOT NULL ) AND ad.entity_name = 'PO_HEADERS') OR
3206: (ad.pk1_value IN (SELECT To_Char(from_line_id)
3207: FROM po_lines_all
3208: WHERE po_header_id = l_po_header_id
3209: AND from_line_id IS NOT NULL ) AND ad.entity_name = 'PO_LINES') OR
3210: (ad.pk1_value IN (SELECT To_Char(line_location_id)
3211: FROM po_line_locations_all

Line 3215: FROM po_lines_all

3211: FROM po_line_locations_all
3212: WHERE po_header_id = l_po_header_id
3213: AND shipment_type IN ('PRICE BREAK', 'STANDARD', 'PREPAYMENT')) AND ad.entity_name = 'PO_SHIPMENTS') OR
3214: (ad.pk2_value IN (SELECT To_Char(item_id)
3215: FROM po_lines_all
3216: WHERE po_header_id = l_po_header_id
3217: AND TO_CHAR(PO_COMMUNICATION_PVT.getInventoryOrgId()) = ad.pk1_value
3218: AND item_id IS NOT NULL ) AND ad.entity_name = 'MTL_SYSTEM_ITEMS') )
3219: AND d.document_id = ad.document_id

Line 3367: FROM po_lines_all

3363: WHERE po_header_id = l_document_id))
3364: AND ad.entity_name = 'PO_VENDORS') OR
3365: --
3366: (ad.pk1_value IN (SELECT po_line_id
3367: FROM po_lines_all
3368: WHERE po_header_id = l_document_id)
3369: AND ad.entity_name = 'PO_LINES') OR
3370: --
3371: (ad.pk1_value IN (SELECT from_header_id

Line 3372: FROM po_lines_all

3368: WHERE po_header_id = l_document_id)
3369: AND ad.entity_name = 'PO_LINES') OR
3370: --
3371: (ad.pk1_value IN (SELECT from_header_id
3372: FROM po_lines_all
3373: WHERE po_header_id = l_document_id
3374: AND from_header_id IS NOT NULL) AND ad.entity_name = 'PO_HEADERS') OR
3375: --
3376: (ad.pk1_value IN (SELECT from_line_id

Line 3377: FROM po_lines_all

3373: WHERE po_header_id = l_document_id
3374: AND from_header_id IS NOT NULL) AND ad.entity_name = 'PO_HEADERS') OR
3375: --
3376: (ad.pk1_value IN (SELECT from_line_id
3377: FROM po_lines_all
3378: WHERE po_header_id = l_document_id
3379: AND from_line_id IS NOT NULL) AND ad.entity_name = 'PO_LINES') OR
3380: --
3381: (ad.pk1_value IN (SELECT line_location_id

Line 3388: FROM po_lines_all

3384: AND shipment_type IN ('PRICE BREAK', 'STANDARD', 'PREPAYMENT'))
3385: AND ad.entity_name = 'PO_SHIPMENTS') OR
3386: --
3387: (ad.pk2_value IN (SELECT item_id
3388: FROM po_lines_all
3389: WHERE po_header_id = l_document_id
3390: AND TO_CHAR(PO_COMMUNICATION_PVT.getInventoryOrgId()) = ad.pk1_value
3391: AND item_id IS NOT NULL) AND ad.entity_name = 'MTL_SYSTEM_ITEMS'))
3392: AND d.document_id = ad.document_id