DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on CZ_CONFIG_ITEMS

Line 7300: CZ_CONFIG_ITEMS cfgdtl,

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

Line 7338: CZ_CONFIG_ITEMS cfgdtl,

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