DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on OE_FRGHT_TERMS_ACTIVE_V

Line 5150: FROM OE_FRGHT_TERMS_ACTIVE_V

5146: AND qpih.freight_terms_code IS NOT NULL
5147: AND qpih.freight_terms_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5148: AND qpih.freight_terms IS NOT NULL
5149: AND NOT EXISTS (SELECT freight_terms_code
5150: FROM OE_FRGHT_TERMS_ACTIVE_V
5151: WHERE freight_terms_code = qpih.freight_terms_code
5152: AND freight_terms = qpih.freight_terms
5153: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5154: AND nvl(end_date_active, sysdate));

Line 5174: FROM OE_FRGHT_TERMS_ACTIVE_V

5170: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5171: AND qpih.freight_terms IS NOT NULL
5172: AND qpih.freight_terms_code IS NULL
5173: AND NOT EXISTS (SELECT freight_terms_code
5174: FROM OE_FRGHT_TERMS_ACTIVE_V
5175: WHERE freight_terms = qpih.freight_terms
5176: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5177: AND nvl(end_date_active, sysdate));
5178:

Line 5198: FROM OE_FRGHT_TERMS_ACTIVE_V

5194: AND qpih.freight_terms IS NULL
5195: AND qpih.freight_terms_code IS NOT NULL
5196: AND qpih.freight_terms_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5197: AND NOT EXISTS (SELECT freight_terms_code
5198: FROM OE_FRGHT_TERMS_ACTIVE_V
5199: WHERE freight_terms_code = qpih.freight_terms_code
5200: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5201: AND nvl(end_date_active, sysdate));
5202: --Bug# 5412029 END RAVI