DBA Data[Home] [Help]

APPS.PO_LOCATIONS_S dependencies on RCV_TRANSACTIONS

Line 1228: FROM RCV_TRANSACTIONS

1224: INTO v_delete_allowed
1225: FROM sys.dual
1226: WHERE NOT EXISTS (
1227: SELECT null
1228: FROM RCV_TRANSACTIONS
1229: WHERE deliver_to_location_id = p_location_id
1230: OR location_id = p_location_id
1231: );
1232:

Line 1239: FROM RCV_TRANSACTIONS_INTERFACE

1235: INTO v_delete_allowed
1236: FROM sys.dual
1237: WHERE NOT EXISTS (
1238: SELECT null
1239: FROM RCV_TRANSACTIONS_INTERFACE
1240: WHERE ship_to_location_id = p_location_id
1241: OR deliver_to_location_id = p_location_id
1242: OR location_id = p_location_id
1243: );