eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_UTILITY_PK dependencies on MTL_SYSTEM_ITEMS

Line 683: from MTL_SYSTEM_ITEMS

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

Line 892: FROM MTL_SYSTEM_ITEMS

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

Line 1508: from mtl_system_items mtl

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

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

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

Line 2320: from oe_order_lines_all OEOL , mtl_system_items MSYI

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

Line 3230: FROM MTL_SYSTEM_ITEMS

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

Line 3336: FROM MTL_SYSTEM_ITEMS

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

Line 3970: and fad.entity_name = 'MTL_SYSTEM_ITEMS'

3966: select fl.file_data into l_blob_loc
3967: from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_tl fdt
3968: where fad.pk1_value = to_char(p_po_val_org_id)
3969: and fad.pk2_value = to_char(p_item_id)
3970: and fad.entity_name = 'MTL_SYSTEM_ITEMS'
3971: and fad.pk3_value = 'CTO:BOM:ATTACHMENT'
3972: and fad.document_id = fdt.document_id
3973: and fdt.media_id = fl.file_id
3974: and fdt.language = userenv('LANG');

Line 4047: p_item_id IN mtl_system_items.inventory_item_id%type,

4043: --- I will add enough comments later for this procedure
4044:
4045:
4046: PROCEDURE create_attachment(
4047: p_item_id IN mtl_system_items.inventory_item_id%type,
4048: p_org_id IN mtl_system_items.organization_id%type,
4049: p_text IN Long,
4050: p_desc IN varchar2,
4051: p_doc_type IN Varchar2,

Line 4048: p_org_id IN mtl_system_items.organization_id%type,

4044:
4045:
4046: PROCEDURE create_attachment(
4047: p_item_id IN mtl_system_items.inventory_item_id%type,
4048: p_org_id IN mtl_system_items.organization_id%type,
4049: p_text IN Long,
4050: p_desc IN varchar2,
4051: p_doc_type IN Varchar2,
4052: x_return_status OUT NOCOPY varchar2) as

Line 4148: where entity_name = 'MTL_SYSTEM_ITEMS'

4144:
4145: select (nvl(max(seq_num),0) + 10)
4146: into l_seq_num
4147: from fnd_attached_documents
4148: where entity_name = 'MTL_SYSTEM_ITEMS'
4149: and pk1_value = to_char(p_org_id) -- 2774570
4150: and pk2_value = to_char(p_item_id); -- 6069512: Added to improve performance, we do not need seq to be unique across items.
4151:
4152:

Line 4165: , x_entity_name => 'MTL_SYSTEM_ITEMS'

4161: (x_rowid => l_row_id
4162: , x_attached_document_id => l_attached_document_id
4163: , x_document_id => l_doc_id
4164: , x_seq_num => l_seq_num
4165: , x_entity_name => 'MTL_SYSTEM_ITEMS'
4166: , x_pk1_value => p_org_id
4167: , x_pk2_value => p_item_id
4168: , x_pk3_value => p_doc_type -- This field is used for procuring config
4169: , x_pk4_value => NULL

Line 4271: l_desc Mtl_system_items_kfv.description%type;

4267: start with line_id = p_line_id
4268: connect by link_to_line_id = prior line_id;
4269:
4270:
4271: l_desc Mtl_system_items_kfv.description%type;
4272: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4273: l_loop_switch Boolean := TRUE;
4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4275: l_model_ord_qty Number;

Line 4272: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;

4268: connect by link_to_line_id = prior line_id;
4269:
4270:
4271: l_desc Mtl_system_items_kfv.description%type;
4272: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4273: l_loop_switch Boolean := TRUE;
4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4275: l_model_ord_qty Number;
4276:

Line 4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;

4270:
4271: l_desc Mtl_system_items_kfv.description%type;
4272: l_prim_uom Mtl_system_items_kfv.primary_uom_code%type;
4273: l_loop_switch Boolean := TRUE;
4274: l_item_name Mtl_system_items_kfv.concatenated_segments%type;
4275: l_model_ord_qty Number;
4276:
4277:
4278: l_new_line varchar2(10) := fnd_global.newline;

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

4391: end if;
4392:
4393:
4394:
4395: --to get the item details from mtl_system_items
4396: select msi.description,
4397: msi.primary_uom_code,
4398: msi.concatenated_segments
4399: into l_desc,

Line 4402: from mtl_system_items_kfv msi

4398: msi.concatenated_segments
4399: into l_desc,
4400: l_prim_uom,
4401: l_item_name
4402: from mtl_system_items_kfv msi
4403: where msi.inventory_item_id = comp_cur.inventory_item_id
4404: and msi.organization_id = comp_cur.ship_from_org_id;
4405:
4406: --for text attachment

Line 4490: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,

4486:
4487:
4488:
4489: FUNCTION CHECK_CONFIG_ITEM(
4490: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
4491: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
4492: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is
4493:
4494: l_found varchar2(1) := 'N';

Line 4491: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,

4487:
4488:
4489: FUNCTION CHECK_CONFIG_ITEM(
4490: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
4491: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
4492: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is
4493:
4494: l_found varchar2(1) := 'N';
4495: l_model_item_id Mtl_system_items.inventory_item_id%type;

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

4488:
4489: FUNCTION CHECK_CONFIG_ITEM(
4490: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
4491: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
4492: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is
4493:
4494: l_found varchar2(1) := 'N';
4495: l_model_item_id Mtl_system_items.inventory_item_id%type;
4496:

Line 4495: l_model_item_id Mtl_system_items.inventory_item_id%type;

4491: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
4492: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2 Is
4493:
4494: l_found varchar2(1) := 'N';
4495: l_model_item_id Mtl_system_items.inventory_item_id%type;
4496:
4497: BEGIN
4498:
4499: /* Select the base model_item_id from the parent. Then compare the given inventory_item with the first

Line 4505: FROM MTL_SYSTEM_ITEMS

4501: */
4502:
4503: SELECT base_item_id
4504: INTO l_model_item_id
4505: FROM MTL_SYSTEM_ITEMS
4506: WHERE Inventory_item_id = p_parent_item_id
4507: AND organization_id = p_organization_id;
4508:
4509: BEGIN

Line 4922: mtl_system_items msi

4918: from
4919: bom_inventory_components bic,
4920: bom_bill_of_materials bbom,
4921: bom_explosion_temp bet,
4922: mtl_system_items msi
4923: where bbom.assembly_item_id = bet.component_item_id
4924: and bbom.organization_id = bet.organization_id
4925: and bbom.alternate_bom_designator is null
4926: and bbom.common_bill_sequence_id = bic.bill_sequence_id

Line 4952: from mtl_system_items msi

4948: delete from bom_explosion_temp bet
4949: where bet.group_id = xGrpId
4950: and bet.component_item_id =
4951: (select msi.inventory_item_id
4952: from mtl_system_items msi
4953: where msi.inventory_item_id = bet.component_item_id
4954: and msi.organization_id = bet.organization_id
4955: and msi.base_item_id is not null
4956: and nvl(msi.auto_created_config_flag, 'N') = 'Y');

Line 5500: from oe_order_lines_all oeol , mtl_system_items msi

5496:
5497: cursor config_update( c_organization_id in number)
5498: is
5499: select line_id, split_from_line_id
5500: from oe_order_lines_all oeol , mtl_system_items msi
5501: where oeol.line_id = p_ato_line_id
5502: and oeol.inventory_item_id = msi.inventory_item_id
5503: and msi.organization_id = c_organization_id
5504: and msi.bom_item_type = 1 ;

Line 5945: lplanner_code mtl_system_items_vl.planner_code%type;

5941: l_atxtvalue wf_engine.texttabtyp;
5942: l_adatevalue wf_engine.datetabtyp;
5943: luser_key varchar2(100);
5944: litem_key varchar2(100);
5945: lplanner_code mtl_system_items_vl.planner_code%type;
5946:
5947: l_dname wf_engine.nametabtyp;
5948: porder_no number := 2222 ;
5949: pline_no number := 1111 ;

Line 6492: FROM mtl_system_items_vl item

6488: -- get the corresponding application user.
6489:
6490: SELECT u.user_name
6491: INTO x_planner_code
6492: FROM mtl_system_items_vl item
6493: ,mtl_planners p
6494: ,fnd_user u
6495: WHERE item.inventory_item_id = p_inventory_item_id
6496: and item.organization_id = p_organization_id

Line 6643: mtl_system_items msi

6639: SELECT distinct nvl(fsp.inventory_organization_id,0) po_valid_org
6640: FROM financials_system_params_all fsp
6641: Where fsp.org_id in (select org.operating_unit
6642: from inv_organization_info_v org,
6643: mtl_system_items msi
6644: where msi.inventory_item_id = p_config_item_id
6645: and msi.organization_id = org.organization_id);
6646:
6647: Begin

Line 6679: AND entity_name = 'MTL_SYSTEM_ITEMS'

6675: INTO l_document_id
6676: FROM FND_ATTACHED_DOCUMENTS
6677: WHERE pk1_value = to_char(config_orgs_rec.po_valid_org) -- 2774570
6678: AND pk2_value = to_char(config_items_rec.config_item_id) -- 2774570
6679: AND entity_name = 'MTL_SYSTEM_ITEMS'
6680: AND Pk3_value = 'CTO:BOM:ATTACHMENT';
6681:
6682: IF PG_DEBUG <> 0 THEN
6683: oe_debug_pub.add('Cto_Utility_pk: '

Line 7207: l_item_id mtl_system_items_kfv.inventory_item_id%type;

7203:
7204: --Bugfix 13554996: New variables
7205: l_conv_qty_lot_level number;
7206: l_conv_qty_item_level number;
7207: l_item_id mtl_system_items_kfv.inventory_item_id%type;
7208: l_order_uom_code oe_order_lines_all.order_quantity_uom%type;
7209:
7210: --This gets the reservation_qty and the type of reservation
7211: -- Modified by Renga Kannan on 06/24/05 for Cross Dock project

Line 7264: -- from mtl_system_items msi,

7260: -- oel.inventory_item_id
7261: -- into x_primary_uom_code,
7262: -- l_order_uom_code,
7263: -- l_item_id
7264: -- from mtl_system_items msi,
7265: -- oe_order_lines_all oel
7266: -- where msi.inventory_item_id = oel.inventory_item_id
7267: -- and msi.organization_id = oel.ship_from_org_id
7268: -- and oel.line_id = p_order_line_id; --bugfix 4557050

Line 7278: from mtl_system_items msi,

7274: into x_primary_uom_code,
7275: l_order_uom_code,
7276: l_item_id,
7277: l_routing_type
7278: from mtl_system_items msi,
7279: oe_order_lines_all oel,
7280: bom_operational_routings bor
7281: where msi.inventory_item_id = oel.inventory_item_id
7282: and msi.organization_id = oel.ship_from_org_id

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

7442: IF PG_DEBUG <> 0 THEN
7443: oe_debug_pub.add('get_resv_qty:'||'flow open quantity =>' || v_open_flow_qty, 5);
7444: END IF;
7445: -- Added by Renga Kannan on 06/27/05
7446: -- Getting the primary uom code from mtl system items.
7447:
7448: If v_open_flow_qty <> 0 then
7449: -- end bugfix 3174334
7450: