DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on OE_FRGHT_TERMS_ACTIVE_V

Line 45: from OE_FRGHT_TERMS_ACTIVE_V c,

41: set (freight_terms_code, process_status_flag, attribute_status)=
42: (select c.freight_terms_code,
43: decode(c.freight_terms_code, null, null, 'P'),
44: decode(c.freight_terms_code, null, ih.attribute_status||'002', ih.attribute_status)
45: from OE_FRGHT_TERMS_ACTIVE_V c,
46: qp_interface_list_headers iih
47: where iih.freight_terms = c.freight_terms(+)
48: and sysdate between nvl(c.start_date_active, sysdate)
49: and nvl(c.end_date_active, sysdate)