APPS.CTO_WORKFLOW_API_PK dependencies on MTL_SYSTEM_ITEMS

Line 549: mtl_system_items msi

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

Line 3326: l_config_orgs mtl_system_items.config_orgs%type ;

3322: v_msg_data varchar2(200) ;
3323: l_stmt_num number ;
3324:
3325:
3326: l_config_orgs mtl_system_items.config_orgs%type ;
3327: l_cfg_item_id mtl_system_items.inventory_item_id%type ;
3328: x_primary_uom_code varchar2(3);
3329:
3330:

Line 3327: l_cfg_item_id mtl_system_items.inventory_item_id%type ;

3323: l_stmt_num number ;
3324:
3325:
3326: l_config_orgs mtl_system_items.config_orgs%type ;
3327: l_cfg_item_id mtl_system_items.inventory_item_id%type ;
3328: x_primary_uom_code varchar2(3);
3329:
3330:
3331: begin

Line 3398: mtl_system_items msi

3394: --instead of waiting for a call for config line
3395: select nvl(msi.config_orgs,1)
3396: into l_config_orgs
3397: from oe_order_lines_all oel,
3398: mtl_system_items msi
3399: where oel.line_id = l_ato_line_id
3400: and msi.inventory_item_id = oel.inventory_item_id
3401: and msi.organization_id = oel.ship_from_org_id;
3402:

Line 3501: x_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%type;

3497: x_msg_count OUT NOCOPY Number) is
3498:
3499: l_stmt_num Number;
3500: l_rsv_rec CTO_UTILITY_PK.resv_tbl_rec_type;
3501: x_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%type;
3502: l_sum_rsv_qty NUMBER;
3503: l_can_create_supply varchar2(1);
3504: --l_source_type VARCHAR2(5); -- bug 4552271. rkaza. 08/15/05.
3505: l_source_type number; --Bug 6470516