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));
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:
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