DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on OE_TRANSACTION_TYPES_TL

Line 7102: oe_transaction_types_tl tran,

7098: mtl_system_items_vl m,
7099: aso_tax_details t,
7100: mtl_units_of_measure u,
7101: Aso_quote_line_details qld,
7102: oe_transaction_types_tl tran,
7103: mtl_units_of_measure_tl uom
7104: WHERE q.inventory_item_id = m.inventory_item_id
7105: and q.organization_id = m.organization_id
7106: and t.quote_line_id(+) = q.quote_line_id

Line 7157: oe_transaction_types_tl tran,

7153: mtl_system_items_vl m,
7154: aso_tax_details t,
7155: mtl_units_of_measure u,
7156: Aso_quote_line_details qld,
7157: oe_transaction_types_tl tran,
7158: mtl_units_of_measure_tl uom
7159: WHERE q.quote_line_id = ALR.related_quote_line_id and
7160: q.inventory_item_id = m.inventory_item_id
7161: and q.organization_id = m.organization_id

Line 7207: oe_transaction_types_tl linetyp

7203: FROM oe_order_lines_all ol,
7204: mtl_system_items_vl msi,
7205: CZ_CONFIG_ITEMS cfgdtl,
7206: mtl_units_of_measure_tl msit1,
7207: oe_transaction_types_tl linetyp
7208: WHERE ol.header_id = p_order_id
7209: 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'
7210: and ol.inventory_item_id = msi.inventory_item_Id
7211: and msit1.language(+) = userenv('LANG')

Line 7245: oe_transaction_types_tl linetyp

7241: FROM oe_order_lines_all ol,
7242: mtl_system_items_vl msi,
7243: CZ_CONFIG_ITEMS cfgdtl,
7244: mtl_units_of_measure_tl msit1,
7245: oe_transaction_types_tl linetyp
7246: WHERE ol.header_id = p_order_id
7247: and link_to_line_id is not null
7248: and ( top_model_line_id = p_mdl_top_line_id)
7249: and ol.inventory_item_id = msi.inventory_item_Id