APPS.CTO_WORKFLOW_API_PK dependencies on MTL_SYSTEM_ITEMS

Line 551: mtl_system_items msi

547: l_ato_line_id,
548: l_top_model_line_id,
549: l_booked_flag
550: from oe_order_lines_all oel,
551: mtl_system_items msi
552: where line_id = p_order_line_id
553: and oel.inventory_item_id = msi.inventory_item_id
554: and oel.ship_from_org_id = msi.organization_id;
555:

Line 3358: l_config_orgs mtl_system_items.config_orgs%type ;

3354: v_msg_data varchar2(200) ;
3355: l_stmt_num number ;
3356:
3357:
3358: l_config_orgs mtl_system_items.config_orgs%type ;
3359: l_cfg_item_id mtl_system_items.inventory_item_id%type ;
3360: x_primary_uom_code varchar2(3);
3361:
3362:

Line 3359: l_cfg_item_id mtl_system_items.inventory_item_id%type ;

3355: l_stmt_num number ;
3356:
3357:
3358: l_config_orgs mtl_system_items.config_orgs%type ;
3359: l_cfg_item_id mtl_system_items.inventory_item_id%type ;
3360: x_primary_uom_code varchar2(3);
3361:
3362:
3363: begin

Line 3430: mtl_system_items msi

3426: --instead of waiting for a call for config line
3427: select nvl(msi.config_orgs,1)
3428: into l_config_orgs
3429: from oe_order_lines_all oel,
3430: mtl_system_items msi
3431: where oel.line_id = l_ato_line_id
3432: and msi.inventory_item_id = oel.inventory_item_id
3433: and msi.organization_id = oel.ship_from_org_id;
3434:

Line 3533: x_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%type;

3529: x_msg_count OUT NOCOPY Number) is
3530:
3531: l_stmt_num Number;
3532: l_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;
3533: x_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%type;
3534: l_sum_rsv_qty NUMBER;
3535: l_can_create_supply varchar2(1);
3536: --l_source_type VARCHAR2(5); -- bug 4552271. rkaza. 08/15/05.
3537: l_source_type number; --Bug 6470516