APPS.QP_BULK_VALIDATE dependencies on OE_SHIP_METHODS_V

Line 5270: FROM OE_SHIP_METHODS_V

5266: AND qpih.ship_method IS NOT NULL
5267: AND qpih.ship_method_code IS NOT NULL
5268: AND qpih.ship_method_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5269: AND NOT EXISTS (SELECT LOOKUP_CODE
5270: FROM OE_SHIP_METHODS_V
5271: WHERE LOOKUP_TYPE = 'SHIP_METHOD'
5272: AND LOOKUP_CODE = qpih.ship_method_code
5273: AND MEANING = qpih.ship_method
5274: AND sysdate BETWEEN nvl(start_date_active, sysdate)

Line 5296: FROM OE_SHIP_METHODS_V

5292: AND qpih.ship_method IS NULL
5293: AND qpih.ship_method_code IS NOT NULL
5294: AND qpih.ship_method_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5295: AND NOT EXISTS (SELECT LOOKUP_CODE
5296: FROM OE_SHIP_METHODS_V
5297: WHERE LOOKUP_TYPE = 'SHIP_METHOD'
5298: AND LOOKUP_CODE = qpih.ship_method_code
5299: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5300: AND nvl(end_date_active, sysdate) );

Line 5320: FROM OE_SHIP_METHODS_V

5316: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5317: AND qpih.ship_method IS NOT NULL
5318: AND qpih.ship_method_code IS NULL
5319: AND NOT EXISTS (SELECT LOOKUP_CODE
5320: FROM OE_SHIP_METHODS_V
5321: WHERE LOOKUP_TYPE = 'SHIP_METHOD'
5322: AND MEANING = qpih.ship_method
5323: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5324: AND nvl(end_date_active, sysdate) );