DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on MTL_SYSTEM_ITEMS

Line 681: from MTL_SYSTEM_ITEMS

677:
678: if( v_source_type_code = 'INTERNAL' ) then
679: select planning_make_buy_code
680: into l_make_buy_code
681: from MTL_SYSTEM_ITEMS
682: where inventory_item_id = pModelItemId
683: and organization_id = pRcvOrgId;
684:
685:

Line 890: FROM MTL_SYSTEM_ITEMS

886: BEGIN
887:
888: SELECT planning_make_buy_code
889: INTO l_make_buy_code
890: FROM MTL_SYSTEM_ITEMS
891: WHERE inventory_item_id = pModelItemId
892: AND organization_id = l_curr_RcvOrgId;
893:
894: EXCEPTION

Line 1506: from mtl_system_items mtl

1502: gLoginId, -- last_update_login
1503: null, -- program_application_id,??
1504: null, -- program_id,??
1505: sysdate -- program_update_date
1506: from mtl_system_items mtl
1507: where inventory_item_id = pModelItemId
1508: and INVENTORY_ITEM_STATUS_CODE = 'Active'
1509: and organization_id not in
1510: (select organization_id

Line 2125: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI

2121: , OEOL.ordered_quantity
2122: , OEOL.order_quantity_uom
2123: , nvl( MSYI.config_orgs , 1)
2124: , MSYI.config_match
2125: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI
2126: where ato_line_id = p_bcol_line_id
2127: and OEOL.component_sequence_id = BIC.component_sequence_id
2128: and OEOL.inventory_item_id = MSYI.inventory_item_id
2129: and MSYI.organization_id = c_organization_id

Line 2318: from oe_order_lines_all OEOL , mtl_system_items MSYI

2314: , v_bcol_wip_supply_type
2315: , v_bcol_order_quantity_uom
2316: , v_bcol_config_creation
2317: , v_bcol_perform_match
2318: from oe_order_lines_all OEOL , mtl_system_items MSYI
2319: where OEOL.ato_line_id = p_bcol_line_id
2320: and OEOL.line_id = p_bcol_line_id
2321: and MSYI.bom_item_type = '1'
2322: and OEOL.inventory_item_id = MSYI.inventory_item_id

Line 3228: FROM MTL_SYSTEM_ITEMS

3224:
3225: IF gMrpAssignmentSet is NULL Then
3226: SELECT planning_make_buy_code
3227: INTO l_make_buy_code
3228: FROM MTL_SYSTEM_ITEMS
3229: WHERE inventory_item_id = p_inventory_item_id
3230: AND organization_id = p_organization_id;
3231:
3232: IF l_make_buy_code = 2 THEN

Line 3334: FROM MTL_SYSTEM_ITEMS

3330: --- so that the calling application will knwo this as buy model
3331:
3332: SELECT planning_make_buy_code
3333: INTO l_make_buy_code
3334: FROM MTL_SYSTEM_ITEMS
3335: WHERE inventory_item_id = p_inventory_item_id
3336: AND organization_id = p_organization_id;
3337:
3338: IF l_make_buy_code = 2 THEN

Line 3948: and fad.entity_name = 'MTL_SYSTEM_ITEMS'

3944: select fl.file_data into l_blob_loc
3945: from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_tl fdt
3946: where fad.pk1_value = to_char(p_po_val_org_id)
3947: and fad.pk2_value = to_char(p_item_id)
3948: and fad.entity_name = 'MTL_SYSTEM_ITEMS'
3949: and fad.pk3_value = 'CTO:BOM:ATTACHMENT'
3950: and fad.document_id = fdt.document_id
3951: and fdt.media_id = fl.file_id
3952: and fdt.language = userenv('LANG');

Line 4025: p_item_id IN mtl_system_items.inventory_item_id%type,

4021: --- I will add enough comments later for this procedure
4022:
4023:
4024: PROCEDURE create_attachment(
4025: p_item_id IN mtl_system_items.inventory_item_id%type,
4026: p_org_id IN mtl_system_items.organization_id%type,
4027: p_text IN Long,
4028: p_desc IN varchar2,
4029: p_doc_type IN Varchar2,

Line 4026: p_org_id IN mtl_system_items.organization_id%type,

4022:
4023:
4024: PROCEDURE create_attachment(
4025: p_item_id IN mtl_system_items.inventory_item_id%type,
4026: p_org_id IN mtl_system_items.organization_id%type,
4027: p_text IN Long,
4028: p_desc IN varchar2,
4029: p_doc_type IN Varchar2,
4030: x_return_status OUT NOCOPY varchar2) as

Line 4124: where entity_name = 'MTL_SYSTEM_ITEMS'

4120:
4121: select (nvl(max(seq_num),0) + 10)
4122: into l_seq_num
4123: from fnd_attached_documents
4124: where entity_name = 'MTL_SYSTEM_ITEMS'
4125: and pk1_value = to_char(p_org_id) -- 2774570
4126: and pk2_value = to_char(p_item_id); -- 6069512: Added to improve performance, we do not need seq to be unique across items.
4127:
4128:

Line 4141: , x_entity_name => 'MTL_SYSTEM_ITEMS'

4137: (x_rowid => l_row_id
4138: , x_attached_document_id => l_attached_document_id
4139: , x_document_id => l_doc_id
4140: , x_seq_num => l_seq_num
4141: , x_entity_name => 'MTL_SYSTEM_ITEMS'
4142: , x_pk1_value => p_org_id
4143: , x_pk2_value => p_item_id
4144: , x_pk3_value => p_doc_type -- This field is used for procuring config
4145: , x_pk4_value => NULL

Line 4247: l_desc Mtl_system_items_kfv.description%type;

4243: start with line_id = p_line_id
4244: connect by link_to_line_id = prior line_id;
4245:
4246:
4247: l_desc Mtl_system_items_kfv.description%type;
4248: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4249: l_loop_switch Boolean := TRUE;
4250: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4251: l_model_ord_qty Number;

Line 4248: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;

4244: connect by link_to_line_id = prior line_id;
4245:
4246:
4247: l_desc Mtl_system_items_kfv.description%type;
4248: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4249: l_loop_switch Boolean := TRUE;
4250: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4251: l_model_ord_qty Number;
4252:

Line 4250: l_item_name Mtl_system_items_kfv.concatenated_segments%type;

4246:
4247: l_desc Mtl_system_items_kfv.description%type;
4248: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4249: l_loop_switch Boolean := TRUE;
4250: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4251: l_model_ord_qty Number;
4252:
4253:
4254: l_new_line varchar2(10) := fnd_global.newline;

Line 4371: --to get the item details from mtl_system_items

4367: end if;
4368:
4369:
4370:
4371: --to get the item details from mtl_system_items
4372: select msi.description,
4373: msi.primary_uom_code,
4374: msi.concatenated_segments
4375: into l_desc,

Line 4378: from mtl_system_items_kfv msi

4374: msi.concatenated_segments
4375: into l_desc,
4376: l_prim_uom,
4377: l_item_name
4378: from mtl_system_items_kfv msi
4379: where msi.inventory_item_id = comp_cur.inventory_item_id
4380: and msi.organization_id = comp_cur.ship_from_org_id;
4381:
4382: --for text attachment

Line 4466: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,

4462:
4463:
4464:
4465: FUNCTION CHECK_CONFIG_ITEM(
4466: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
4467: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
4468: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is
4469:
4470: l_found varchar2(1) := 'N';

Line 4467: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,

4463:
4464:
4465: FUNCTION CHECK_CONFIG_ITEM(
4466: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
4467: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
4468: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is
4469:
4470: l_found varchar2(1) := 'N';
4471: l_model_item_id Mtl_system_items.inventory_item_id%type;

Line 4468: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is

4464:
4465: FUNCTION CHECK_CONFIG_ITEM(
4466: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
4467: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
4468: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is
4469:
4470: l_found varchar2(1) := 'N';
4471: l_model_item_id Mtl_system_items.inventory_item_id%type;
4472:

Line 4471: l_model_item_id Mtl_system_items.inventory_item_id%type;

4467: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
4468: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is
4469:
4470: l_found varchar2(1) := 'N';
4471: l_model_item_id Mtl_system_items.inventory_item_id%type;
4472:
4473: BEGIN
4474:
4475: /* Select the base model_item_id from the parent. Then compare the given inventory_item with the first

Line 4481: FROM MTL_SYSTEM_ITEMS

4477: */
4478:
4479: SELECT base_item_id
4480: INTO l_model_item_id
4481: FROM MTL_SYSTEM_ITEMS
4482: WHERE Inventory_item_id = p_parent_item_id
4483: AND organization_id = p_organization_id;
4484:
4485: BEGIN

Line 4898: mtl_system_items msi

4894: from
4895: bom_inventory_components bic,
4896: bom_bill_of_materials bbom,
4897: bom_explosion_temp bet,
4898: mtl_system_items msi
4899: where bbom.assembly_item_id = bet.component_item_id
4900: and bbom.organization_id = bet.organization_id
4901: and bbom.alternate_bom_designator is null
4902: and bbom.common_bill_sequence_id = bic.bill_sequence_id

Line 4928: from mtl_system_items msi

4924: delete from bom_explosion_temp bet
4925: where bet.group_id = xGrpId
4926: and bet.component_item_id =
4927: (select msi.inventory_item_id
4928: from mtl_system_items msi
4929: where msi.inventory_item_id = bet.component_item_id
4930: and msi.organization_id = bet.organization_id
4931: and msi.base_item_id is not null
4932: and nvl(msi.auto_created_config_flag, 'N') = 'Y');

Line 5476: from oe_order_lines_all oeol , mtl_system_items msi

5472:
5473: cursor config_update( c_organization_id in number)
5474: is
5475: select line_id, split_from_line_id
5476: from oe_order_lines_all oeol , mtl_system_items msi
5477: where oeol.line_id = p_ato_line_id
5478: and oeol.inventory_item_id = msi.inventory_item_id
5479: and msi.organization_id = c_organization_id
5480: and msi.bom_item_type = 1 ;

Line 5921: lplanner_code mtl_system_items_vl.planner_code%type;

5917: l_atxtvalue wf_engine.texttabtyp;
5918: l_adatevalue wf_engine.datetabtyp;
5919: luser_key varchar2(100);
5920: litem_key varchar2(100);
5921: lplanner_code mtl_system_items_vl.planner_code%type;
5922:
5923: l_dname wf_engine.nametabtyp;
5924: porder_no number := 2222 ;
5925: pline_no number := 1111 ;

Line 6468: FROM mtl_system_items_vl item

6464: -- get the corresponding application user.
6465:
6466: SELECT u.user_name
6467: INTO x_planner_code
6468: FROM mtl_system_items_vl item
6469: ,mtl_planners p
6470: ,fnd_user u
6471: WHERE item.inventory_item_id = p_inventory_item_id
6472: and item.organization_id = p_organization_id

Line 6619: mtl_system_items msi

6615: SELECT distinct nvl(fsp.inventory_organization_id,0) po_valid_org
6616: FROM financials_system_params_all fsp
6617: Where fsp.org_id in (select org.operating_unit
6618: from inv_organization_info_v org,
6619: mtl_system_items msi
6620: where msi.inventory_item_id = p_config_item_id
6621: and msi.organization_id = org.organization_id);
6622:
6623: Begin

Line 6655: AND entity_name = 'MTL_SYSTEM_ITEMS'

6651: INTO l_document_id
6652: FROM FND_ATTACHED_DOCUMENTS
6653: WHERE pk1_value = to_char(config_orgs_rec.po_valid_org) -- 2774570
6654: AND pk2_value = to_char(config_items_rec.config_item_id) -- 2774570
6655: AND entity_name = 'MTL_SYSTEM_ITEMS'
6656: AND Pk3_value = 'CTO:BOM:ATTACHMENT';
6657:
6658: IF PG_DEBUG <> 0 THEN
6659: oe_debug_pub.add('Cto_Utility_pk: '

Line 7224: from mtl_system_items msi,

7220: x_return_status := FND_API.G_RET_STS_SUCCESS;
7221: --need this for flow and interface data alone
7222: Select msi.primary_uom_code
7223: into x_primary_uom_code
7224: from mtl_system_items msi,
7225: oe_order_lines_all oel
7226: where msi.inventory_item_id = oel.inventory_item_id
7227: and msi.organization_id = oel.ship_from_org_id
7228: and oel.line_id = p_order_line_id; --bugfix 4557050

Line 7326: -- Getting the primary uom code from mtl system items.

7322: IF PG_DEBUG <> 0 THEN
7323: oe_debug_pub.add('get_resv_qty:'||'flow open quantity =>' || v_open_flow_qty, 5);
7324: END IF;
7325: -- Added by Renga Kannan on 06/27/05
7326: -- Getting the primary uom code from mtl system items.
7327:
7328: If v_open_flow_qty <> 0 then
7329:
7330: