DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on CZ_CONFIG_ITEMS

Line 7205: CZ_CONFIG_ITEMS cfgdtl,

7201: decode(msi.config_model_type,'N','Y','N') model_container_flag,
7202: cfgdtl.config_delta config_delta_flag
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'

Line 7243: CZ_CONFIG_ITEMS cfgdtl,

7239: decode(msi.config_model_type,'N','Y','N') model_container_flag,
7240: cfgdtl.config_delta config_delta_flag
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