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

Line 1647: po_lines_all pl

1643: SELECT NVL(MIN(allow_substitute_receipts_flag),'N')
1644: INTO x_allow_sub_flag
1645: FROM (SELECT msi.allow_substitute_receipts_flag
1646: FROM mtl_system_items msi,
1647: po_lines_all pl
1648: WHERE msi.inventory_item_id = pl.item_id
1649: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1650: AND msi.organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)
1651: UNION ALL

Line 1705: po_lines_all pl

1701:
1702: SELECT NVL(MAX(inventory_item_id), 0)
1703: INTO x_inventory_item
1704: FROM mtl_related_items mri,
1705: po_lines_all pl
1706: WHERE mri.inventory_item_id = pl.item_id
1707: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1708: AND mri.related_item_id = x_cascaded_table(n).substitute_item_id
1709: AND mri.relationship_type_id = 2; -- substitute items

Line 1732: po_lines_all pl

1728:
1729: SELECT NVL(MAX(inventory_item_id), 0)
1730: INTO x_inventory_item
1731: FROM mtl_related_items mri,
1732: po_lines_all pl
1733: WHERE mri.related_item_id = pl.item_id
1734: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1735: AND mri.inventory_item_id = x_cascaded_table(n).substitute_item_id
1736: AND mri.reciprocal_flag = 'Y'