APPS.QP_BULK_VALIDATE dependencies on OE_SHIP_METHODS_V

Line 5258: FROM OE_SHIP_METHODS_V

5254: AND qpih.ship_method IS NOT NULL
5255: AND qpih.ship_method_code IS NOT NULL
5256: AND qpih.ship_method_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5257: AND NOT EXISTS (SELECT LOOKUP_CODE
5258: FROM OE_SHIP_METHODS_V
5259: WHERE LOOKUP_TYPE = 'SHIP_METHOD'
5260: AND LOOKUP_CODE = qpih.ship_method_code
5261: AND MEANING = qpih.ship_method
5262: AND sysdate BETWEEN nvl(start_date_active, sysdate)

Line 5284: FROM OE_SHIP_METHODS_V

5280: AND qpih.ship_method IS NULL
5281: AND qpih.ship_method_code IS NOT NULL
5282: AND qpih.ship_method_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5283: AND NOT EXISTS (SELECT LOOKUP_CODE
5284: FROM OE_SHIP_METHODS_V
5285: WHERE LOOKUP_TYPE = 'SHIP_METHOD'
5286: AND LOOKUP_CODE = qpih.ship_method_code
5287: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5288: AND nvl(end_date_active, sysdate) );

Line 5308: FROM OE_SHIP_METHODS_V

5304: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5305: AND qpih.ship_method IS NOT NULL
5306: AND qpih.ship_method_code IS NULL
5307: AND NOT EXISTS (SELECT LOOKUP_CODE
5308: FROM OE_SHIP_METHODS_V
5309: WHERE LOOKUP_TYPE = 'SHIP_METHOD'
5310: AND MEANING = qpih.ship_method
5311: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5312: AND nvl(end_date_active, sysdate) );