DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on OE_FRGHT_TERMS_ACTIVE_V

Line 5162: FROM OE_FRGHT_TERMS_ACTIVE_V

5158: AND qpih.freight_terms_code IS NOT NULL
5159: AND qpih.freight_terms_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5160: AND qpih.freight_terms IS NOT NULL
5161: AND NOT EXISTS (SELECT freight_terms_code
5162: FROM OE_FRGHT_TERMS_ACTIVE_V
5163: WHERE freight_terms_code = qpih.freight_terms_code
5164: AND freight_terms = qpih.freight_terms
5165: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5166: AND nvl(end_date_active, sysdate));

Line 5186: FROM OE_FRGHT_TERMS_ACTIVE_V

5182: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5183: AND qpih.freight_terms IS NOT NULL
5184: AND qpih.freight_terms_code IS NULL
5185: AND NOT EXISTS (SELECT freight_terms_code
5186: FROM OE_FRGHT_TERMS_ACTIVE_V
5187: WHERE freight_terms = qpih.freight_terms
5188: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5189: AND nvl(end_date_active, sysdate));
5190:

Line 5210: FROM OE_FRGHT_TERMS_ACTIVE_V

5206: AND qpih.freight_terms IS NULL
5207: AND qpih.freight_terms_code IS NOT NULL
5208: AND qpih.freight_terms_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5209: AND NOT EXISTS (SELECT freight_terms_code
5210: FROM OE_FRGHT_TERMS_ACTIVE_V
5211: WHERE freight_terms_code = qpih.freight_terms_code
5212: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5213: AND nvl(end_date_active, sysdate));
5214: --Bug# 5412029 END RAVI