eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_CONFIG_UTIL dependencies on OE_LINES_IFACE_ALL

Line 1645: OE_LINES_IFACE_ALL L ,

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
1649: AND h.order_source_id = l.order_source_id

Line 1678: OE_LINES_IFACE_ALL L

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
1682: AND nvl(h.error_flag,'N') = 'N'

Line 1932: from oe_lines_iface_all l

1928: WHERE z.config_hdr_id = l_line_rec.config_header_id(I)
1929: AND z.config_rev_nbr = l_line_rec.config_rev_nbr(I)
1930: AND NOT EXISTS (
1931: Select l.line_id
1932: from oe_lines_iface_all l
1933: WHERE NVL(l.configuration_id, z.config_item_id) = z.config_item_id
1934: AND NVL(l.component_code, z.component_code) = z.component_code
1935: AND l.top_model_line_ref = l_line_rec.ORIG_SYS_LINE_REF(I)
1936: AND l.orig_sys_document_ref = l_line_rec.ORIG_SYS_DOCUMENT_REF(I)

Line 2009: FROM cz_config_details_v z, oe_lines_iface_all l

2005: null MUTUALLY_EXCLUSIVE_OPTIONS,
2006: null BOM_ITEM_TYPE,
2007: l_line_rec.lock_control(I) LOCK_CONTROL,
2008: null REPLENISH_TO_ORDER_FLAG
2009: FROM cz_config_details_v z, oe_lines_iface_all l
2010: WHERE z.config_hdr_id = l_line_rec.config_header_id(I)
2011: AND z.config_rev_nbr = l_line_rec.config_rev_nbr(I)
2012: AND NVL(l.configuration_id,z.config_item_id) = z.config_item_id
2013: AND NVL(l.component_code, z.component_code) = z.component_code

Line 2153: OE_LINES_IFACE_ALL L,

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
2157: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 2198: OE_LINES_IFACE_ALL L

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
2202: AND nvl(h.error_flag,'N') = 'N'