DBA Data[Home] [Help]

APPS.BOMPLDCB dependencies on MTL_SYSTEM_ITEMS

Line 113: from mtl_system_items_interface

109: where id_flex_code = 'MICG'
110: and application_id = 401;
111:
112: select item_catalog_group_id into group_id
113: from mtl_system_items_interface
114: where inventory_item_id = item_id
115: and organization_id = org_id;
116:
117: idx := 0;

Line 140: update mtl_system_items_interface

136: end loop;
137: close cc;
138:
139: if idx <> 0 then
140: update mtl_system_items_interface
141: set description = cat_value
142: where inventory_item_id = item_id
143: and organization_id = org_id;
144: end if;

Line 222: from mtl_system_items_interface

218: ** declare cursor to retrieve config items
219: */
220: CURSOR ee IS
221: select inventory_item_id, organization_id
222: from mtl_system_items_interface
223: where set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
224:
225: routing_id NUMBER;
226: bill_id NUMBER;

Line 337: MTL_SYSTEM_ITEMS_INTERFACE m

333: m.demand_source_header_id,
334: m.set_id
335: from
336: BOM_BILL_OF_MATERIALS b,
337: MTL_SYSTEM_ITEMS_INTERFACE m
338: where m.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
339: and m.copy_item_id = b.assembly_item_id
340: and m.organization_id = b.organization_id
341: and b.alternate_bom_designator is NULL;

Line 753: mtl_system_items si1,

749: from
750: bom_bill_of_mtls_interface b1,
751: mtl_demand d2, /* Model-Parent */
752: mtl_demand d1, /* Standard Mandatory comp */
753: mtl_system_items si1,
754: bom_bill_of_materials b,
755: bom_inventory_components ic1
756: where d1.organization_id = si1.organization_id
757: and d1.inventory_item_id = si1.inventory_item_id

Line 1202: MTL_SYSTEM_ITEMS_INTERFACE m

1198: from
1199: BOM_OPERATIONAL_ROUTINGS b,
1200: MTL_DEMAND d,
1201: MTL_PARAMETERS mp,
1202: MTL_SYSTEM_ITEMS_INTERFACE m
1203: where m.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1204: and d.demand_source_line = m.demand_source_line
1205: and d.demand_source_type = m.demand_source_type
1206: and d.demand_source_header_id = m.demand_source_header_id

Line 1239: mtl_system_items_interface m

1235: Update BOM_OP_ROUTINGS_INTERFACE b
1236: set mixed_model_map_flag =
1237: ( select 1
1238: from bom_operational_routings b1,
1239: mtl_system_items_interface m
1240: where b.assembly_item_id = m.inventory_item_id
1241: and b.organization_id = m.organization_id
1242: and m.set_id = to_char(to_number(USERENV('SESSIONID')))
1243: and b1.assembly_item_id = m.copy_item_id

Line 1383: mtl_system_items si1,

1379: from
1380: bom_op_routings_interface b1,
1381: mtl_demand d2,/* Model for est. release date */
1382: mtl_demand d1,
1383: mtl_system_items si1,
1384: bom_operational_routings or1,
1385: bom_operation_sequences os1
1386: where b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1387: and d1.rto_model_source_line = b1.demand_source_line

Line 1538: mtl_system_items si1,

1534: from
1535: bom_op_routings_interface b1,
1536: mtl_demand d2,/* Model for est. release date */
1537: mtl_demand d1,
1538: mtl_system_items si1,
1539: bom_operational_routings or1,
1540: bom_operation_sequences os1
1541: where b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1542: and d1.rto_model_source_line = b1.demand_source_line

Line 1873: mtl_system_items si2,

1869: Net_planning_percent
1870: from
1871: bom_operation_sequences os1,
1872: bom_operational_routings or1,
1873: mtl_system_items si2,
1874: bom_inventory_components ic1,
1875: bom_bill_of_materials b1,
1876: mtl_system_items si1,
1877: mtl_demand d2, /* Model if option class */

Line 1876: mtl_system_items si1,

1872: bom_operational_routings or1,
1873: mtl_system_items si2,
1874: bom_inventory_components ic1,
1875: bom_bill_of_materials b1,
1876: mtl_system_items si1,
1877: mtl_demand d2, /* Model if option class */
1878: mtl_demand d1, /* Model or option class */
1879: bom_op_routings_interface b
1880: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 2014: mtl_system_items ms,

2010: (select /o+ ORDERED o/
2011: s.operation_seq_num
2012: from
2013: mtl_demand md,
2014: mtl_system_items ms,
2015: bom_operational_routings r,
2016: bom_operation_sequences s,
2017: bom_op_routings_interface ri
2018: where ri.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 2360: from mtl_system_items_interface m

2356: and v.inventory_item_id = bci.component_item_id
2357: and v.element_name = i.element_name)
2358: where i.inventory_item_id =
2359: (select inventory_item_id
2360: from mtl_system_items_interface m
2361: where inventory_item_id = i.inventory_item_id
2362: and set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
2363:
2364: /*

Line 2366: ** the MTL_SYSTEM_ITEMS_INTERFACE

2362: and set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
2363:
2364: /*
2365: ** Update descriptions of the config items in
2366: ** the MTL_SYSTEM_ITEMS_INTERFACE
2367: */
2368: stmt_num := 220;
2369: open ee;
2370: