DBA Data[Home] [Help]

APPS.OE_BULK_CONFIG_UTIL dependencies on OE_HEADERS_IFACE_ALL

Line 1644: FROM OE_HEADERS_IFACE_ALL H,

1640: nvl(h.booked_flag,decode(a.order_source_id,NULL,'N','Y')) booked_flag,
1641: decode(l.ordered_quantity, nvl(z.quantity, l.ordered_quantity),'Y','N')
1642: cz_qty_match_flag,
1643: nvl(l.component_code, z.component_code) component_code
1644: FROM OE_HEADERS_IFACE_ALL H,
1645: OE_LINES_IFACE_ALL L ,
1646: CZ_CONFIG_DETAILS_V Z,
1647: OE_ACTIONS_INTERFACE a
1648: WHERE h.batch_id = p_batch_id

Line 1677: FROM OE_HEADERS_IFACE_ALL H,

1673: l.orig_sys_line_ref,
1674: l.orig_sys_shipment_ref,
1675: l.order_source_id,
1676: l.ordered_quantity
1677: FROM OE_HEADERS_IFACE_ALL H,
1678: OE_LINES_IFACE_ALL L
1679: WHERE h.batch_id = p_batch_id
1680: AND h.order_source_id = l.order_source_id
1681: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 2152: FROM OE_HEADERS_IFACE_ALL H,

2148: l.ship_from_org_id,
2149: h.header_id,
2150: nvl(h.booked_flag,decode(a.order_source_id,NULL,'N','Y')) booked_flag,
2151: 'N' cz_qty_match_flag
2152: FROM OE_HEADERS_IFACE_ALL H,
2153: OE_LINES_IFACE_ALL L,
2154: OE_ACTIONS_INTERFACE a
2155: WHERE h.batch_id = p_batch_id
2156: AND h.order_source_id = l.order_source_id

Line 2197: FROM OE_HEADERS_IFACE_ALL H,

2193: l.customer_item_id,
2194: l.customer_item_name,
2195: l.sold_to_org_id,
2196: l.ship_from_org_id
2197: FROM OE_HEADERS_IFACE_ALL H,
2198: OE_LINES_IFACE_ALL L
2199: WHERE h.batch_id = p_batch_id
2200: AND h.order_source_id = l.order_source_id
2201: AND h.orig_sys_document_ref = l.orig_sys_document_ref