APPS.RCV_ROI_HEADER_COMMON dependencies on PO_LINE_LOCATIONS

Line 1730: FROM po_line_locations

1726: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1727: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)
1728: UNION ALL
1729: SELECT allow_substitute_receipts_flag
1730: FROM po_line_locations
1731: WHERE line_location_id = x_cascaded_table(n).po_line_location_id);
1732: */
1733: -- Bugfix 5219284, Abobe query is replaced with following for performance reason.
1734:

Line 1739: FROM po_line_locations

1735: -- Bug 13926508: Only validate allow_substitute_receipts_flag at PO shipment level during ROI Receipts
1736:
1737: SELECT NVL(allow_substitute_receipts_flag, 'N')
1738: INTO x_allow_sub_flag
1739: FROM po_line_locations
1740: WHERE line_location_id = x_cascaded_table(n).po_line_location_id;
1741:
1742: IF (x_allow_sub_flag = 'N') THEN
1743: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_ALLOWED');