DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on OE_SHIP_METHODS_V

Line 68: from OE_SHIP_METHODS_V c,

64: set (ship_method_code, process_status_flag, attribute_status)=
65: (select c.lookup_code,
66: decode(c.lookup_code, null, null, 'P'),
67: decode(c.lookup_code, null, ih.attribute_status||'003', ih.attribute_status)
68: from OE_SHIP_METHODS_V c,
69: qp_interface_list_headers iih
70: where iih.ship_method = c.meaning(+)
71: and c.lookup_type(+) = 'SHIP_METHOD'
72: and sysdate between nvl(c.start_date_active, sysdate)