APPS.OE_BULK_VALUE_TO_ID dependencies on QP_LIST_HEADERS_VL

Line 410: FROM qp_list_headers_vl b, OE_HEADERS_IFACE_ALL d

406: (SELECT b.LIST_HEADER_ID,
407: DECODE(b.LIST_HEADER_ID,NULL,'Y',NULL),
408: DECODE(b.LIST_HEADER_ID,NULL,
409: c.ATTRIBUTE_STATUS||'003',c.ATTRIBUTE_STATUS)
410: FROM qp_list_headers_vl b, OE_HEADERS_IFACE_ALL d
411: WHERE d.price_list = b.name(+)
412: AND NVL(b.list_type_code,'PRL') IN ('PRL', 'AGR')
413: AND nvl(b.active_flag,'Y') = 'Y'
414: AND d.rowid = c.rowid

Line 1216: FROM qp_list_headers_vl b, OE_LINES_IFACE_ALL d

1212: (SELECT b.LIST_HEADER_ID,
1213: DECODE(b.LIST_HEADER_ID,NULL,'Y',NULL),
1214: DECODE(b.LIST_HEADER_ID,NULL,
1215: c.ATTRIBUTE_STATUS||'003',c.ATTRIBUTE_STATUS)
1216: FROM qp_list_headers_vl b, OE_LINES_IFACE_ALL d
1217: WHERE d.price_list = b.name(+)
1218: AND NVL(b.list_type_code,'PRL') IN ('PRL', 'AGR')
1219: AND nvl(b.active_flag,'Y') = 'Y'
1220: AND d.rowid = c.rowid