APPS.RCV_ROI_HEADER_COMMON dependencies on PO_LINE_LOCATIONS

Line 1638: FROM po_line_locations

1634: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1635: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)
1636: UNION ALL
1637: SELECT allow_substitute_receipts_flag
1638: FROM po_line_locations
1639: WHERE line_location_id = x_cascaded_table(n).po_line_location_id);
1640: */
1641: -- Bugfix 5219284, Abobe query is replaced with following for performance reason.
1642:

Line 1653: FROM po_line_locations

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
1652: SELECT allow_substitute_receipts_flag
1653: FROM po_line_locations
1654: WHERE line_location_id = x_cascaded_table(n).po_line_location_id);
1655: IF (x_allow_sub_flag = 'N') THEN
1656: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_ALLOWED');
1657: RAISE e_validation_error;