APPS.IBE_WORKFLOW_PVT dependencies on OE_TRANSACTION_TYPES_TL

Line 7197: oe_transaction_types_tl tran,

7193: mtl_system_items_vl m,
7194: aso_tax_details t,
7195: mtl_units_of_measure u,
7196: Aso_quote_line_details qld,
7197: oe_transaction_types_tl tran,
7198: mtl_units_of_measure_tl uom
7199: WHERE q.inventory_item_id = m.inventory_item_id
7200: and q.organization_id = m.organization_id
7201: and t.quote_line_id(+) = q.quote_line_id

Line 7252: oe_transaction_types_tl tran,

7248: mtl_system_items_vl m,
7249: aso_tax_details t,
7250: mtl_units_of_measure u,
7251: Aso_quote_line_details qld,
7252: oe_transaction_types_tl tran,
7253: mtl_units_of_measure_tl uom
7254: WHERE q.quote_line_id = ALR.related_quote_line_id and
7255: q.inventory_item_id = m.inventory_item_id
7256: and q.organization_id = m.organization_id

Line 7302: oe_transaction_types_tl linetyp

7298: FROM oe_order_lines_all ol,
7299: mtl_system_items_vl msi,
7300: CZ_CONFIG_ITEMS cfgdtl,
7301: mtl_units_of_measure_tl msit1,
7302: oe_transaction_types_tl linetyp
7303: WHERE ol.header_id = p_order_id
7304: AND decode(ol.top_model_line_id,null,'1',decode(ol.top_model_line_id,ol.line_id,decode(ol.link_to_line_id,null,'1','2'),'2'))= '1'
7305: and ol.inventory_item_id = msi.inventory_item_Id
7306: and msit1.language(+) = userenv('LANG')

Line 7340: oe_transaction_types_tl linetyp

7336: FROM oe_order_lines_all ol,
7337: mtl_system_items_vl msi,
7338: CZ_CONFIG_ITEMS cfgdtl,
7339: mtl_units_of_measure_tl msit1,
7340: oe_transaction_types_tl linetyp
7341: WHERE ol.header_id = p_order_id
7342: and link_to_line_id is not null
7343: and ( top_model_line_id = p_mdl_top_line_id)
7344: and ol.inventory_item_id = msi.inventory_item_Id