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.BOM_COMPONENT_API dependencies on MTL_SYSTEM_ITEMS

Line 156: SET transaction_id = mtl_system_items_interface_s.nextval,

152: */
153: stmt_num := 1;
154: LOOP
155: UPDATE bom_inventory_comps_interface
156: SET transaction_id = mtl_system_items_interface_s.nextval,
157: component_sequence_id = bom_inventory_components_s.nextval,
158: transaction_type = upper(transaction_type)
159: WHERE transaction_id is null
160: AND process_flag = 1

Line 177: SET transaction_id = mtl_system_items_interface_s.nextval,

173: */
174: stmt_num := 1;
175: LOOP
176: UPDATE bom_inventory_comps_interface
177: SET transaction_id = mtl_system_items_interface_s.nextval,
178: transaction_type = upper(transaction_type)
179: WHERE transaction_id is null
180: AND process_flag = 1
181: AND upper(transaction_type) in (G_UPDATE, G_DELETE)

Line 275: mtl_system_items msi

271: SELECT bom.bill_sequence_id, msi.bom_item_type,
272: msi.atp_components_flag
273: INTO c1rec.BSI, x_bom_item_type, x_atp_comp_flag
274: FROM bom_bill_of_materials bom,
275: mtl_system_items msi
276: WHERE bom.organization_id = c1rec.OI
277: AND bom.assembly_item_id = c1rec.AII
278: AND nvl(bom.alternate_bom_designator, 'NONE') =
279: nvl(c1rec.ABD, 'NONE')

Line 317: mtl_system_items msi

313: msi.atp_components_flag
314: INTO c1rec.AII, c1rec.OI, c1rec.ABD, x_bom_item_type,
315: x_atp_comp_flag
316: FROM bom_bill_of_materials bom,
317: mtl_system_items msi
318: WHERE bom.bill_sequence_id = c1rec.BSI
319: AND msi.organization_id = bom.organization_id
320: AND msi.inventory_item_id = bom.assembly_item_id;
321: EXCEPTION

Line 401: FROM mtl_system_items

397: -- get the wip values from item master
398: SELECT wip_supply_type, wip_supply_subinventory,
399: wip_supply_locator_id
400: INTO c1rec.wst, c1rec.SS, c1rec.SLI
401: FROM mtl_system_items
402: WHERE organization_id = c1rec.OI
403: AND inventory_item_id = c1rec.CII;
404:
405: EXCEPTION

Line 447: FROM mtl_system_items

443: BEGIN
444: SELECT bom_item_type, default_include_in_rollup_flag,
445: atp_flag, pick_components_flag
446: INTO c1rec.BIT, x_rollup_flag, x_atp_flag, x_pick_components
447: FROM mtl_system_items
448: WHERE organization_id = c1rec.OI
449: AND inventory_item_id = c1rec.CII;
450: EXCEPTION
451: WHEN no_data_found THEN

Line 766: mtl_system_items msi

762: SELECT bom.bill_sequence_id, bom.assembly_type,
763: msi.bom_item_type
764: INTO c2rec.BSI, c2rec.AST, x_bom_item_type
765: FROM bom_bill_of_materials bom,
766: mtl_system_items msi
767: WHERE bom.organization_id = c2rec.OI
768: AND bom.assembly_item_id = c2rec.AII
769: AND nvl(bom.alternate_bom_designator, 'NONE') =
770: nvl(c2rec.ABD, 'NONE')

Line 808: mtl_system_items msi

804: msi.bom_item_type
805: INTO c2rec.AII, c2rec.OI, c2rec.ABD, c2rec.AST,
806: x_bom_item_type
807: FROM bom_bill_of_materials bom,
808: mtl_system_items msi
809: WHERE bom.bill_sequence_id = c2rec.BSI
810: AND msi.organization_id = bom.organization_id
811: AND msi.inventory_item_id = bom.assembly_item_id;
812: EXCEPTION

Line 917: FROM mtl_system_items msi,

913: bbom.alternate_bom_designator, bbom.assembly_type,
914: bic.component_item_id, msi.bom_item_type
915: INTO c2rec.AII, c2rec.OI, c2rec.BSI, c2rec.ABD, c2rec.AST,
916: c2rec.CII, x_bom_item_type
917: FROM mtl_system_items msi,
918: bom_bill_of_materials bbom,
919: bom_inventory_components bic
920: WHERE bbom.bill_sequence_id = bic.bill_sequence_id
921: AND bic.component_sequence_id = c2rec.CSI

Line 1554: assy_atp_components_flag mtl_system_items.atp_components_flag%type;

1550: stmt_num NUMBER := 0;
1551: dummy NUMBER;
1552: l_atp_comps_flag VARCHAR2(1);
1553: l_atp_flag VARCHAR2(1);
1554: assy_atp_components_flag mtl_system_items.atp_components_flag%type;
1555: assy_wip_supply_type mtl_system_items.wip_supply_type%type;
1556: assy_replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type;
1557: assy_pick_components_flag mtl_system_items.pick_components_flag%type;
1558:

Line 1555: assy_wip_supply_type mtl_system_items.wip_supply_type%type;

1551: dummy NUMBER;
1552: l_atp_comps_flag VARCHAR2(1);
1553: l_atp_flag VARCHAR2(1);
1554: assy_atp_components_flag mtl_system_items.atp_components_flag%type;
1555: assy_wip_supply_type mtl_system_items.wip_supply_type%type;
1556: assy_replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type;
1557: assy_pick_components_flag mtl_system_items.pick_components_flag%type;
1558:
1559: BEGIN

Line 1556: assy_replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type;

1552: l_atp_comps_flag VARCHAR2(1);
1553: l_atp_flag VARCHAR2(1);
1554: assy_atp_components_flag mtl_system_items.atp_components_flag%type;
1555: assy_wip_supply_type mtl_system_items.wip_supply_type%type;
1556: assy_replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type;
1557: assy_pick_components_flag mtl_system_items.pick_components_flag%type;
1558:
1559: BEGIN
1560: stmt_num := 1;

Line 1557: assy_pick_components_flag mtl_system_items.pick_components_flag%type;

1553: l_atp_flag VARCHAR2(1);
1554: assy_atp_components_flag mtl_system_items.atp_components_flag%type;
1555: assy_wip_supply_type mtl_system_items.wip_supply_type%type;
1556: assy_replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type;
1557: assy_pick_components_flag mtl_system_items.pick_components_flag%type;
1558:
1559: BEGIN
1560: stmt_num := 1;
1561: SELECT 1

Line 1563: FROM mtl_system_items assy, mtl_system_items comp

1559: BEGIN
1560: stmt_num := 1;
1561: SELECT 1
1562: INTO dummy
1563: FROM mtl_system_items assy, mtl_system_items comp
1564: WHERE comp.organization_id = org_id
1565: AND assy.organization_id = org_id
1566: AND comp.inventory_item_id = cmp_id
1567: AND assy.inventory_item_id = assy_id

Line 1626: FROM mtl_system_items

1622: INTO assy_atp_components_flag,
1623: assy_wip_supply_type,
1624: assy_replenish_to_order_flag,
1625: assy_pick_components_flag
1626: FROM mtl_system_items
1627: WHERE inventory_item_id = assy_id
1628: AND organization_id = org_id;
1629:
1630: SELECT atp_components_flag,

Line 1634: FROM mtl_system_items msi

1630: SELECT atp_components_flag,
1631: atp_flag
1632: INTO l_atp_comps_flag,
1633: l_atp_flag
1634: FROM mtl_system_items msi
1635: WHERE inventory_item_id = cmp_id
1636: AND organization_id = org_id;
1637:
1638: IF((assy_atp_components_flag = 'N' AND

Line 1671: FROM mtl_system_items assy, mtl_system_items comp

1667:
1668: /*
1669: SELECT 1
1670: INTO dummy
1671: FROM mtl_system_items assy, mtl_system_items comp
1672: WHERE comp.organization_id = org_id
1673: AND assy.organization_id = org_id
1674: AND comp.inventory_item_id = cmp_id
1675: AND assy.inventory_item_id = assy_id

Line 1730: FROM mtl_system_items

1726: BEGIN
1727: stmt_num := 1;
1728: SELECT bom_item_type
1729: INTO dummy
1730: FROM mtl_system_items
1731: WHERE organization_id = org_id
1732: AND inventory_item_id = assy_id;
1733:
1734: IF (dummy = 3 and op_seq <> 1) THEN

Line 1926: FROM mtl_system_items msic,

1922: msia.replenish_to_order_flag RTOF,
1923: msic.replenish_to_order_flag RTOFC,
1924: msia.atp_components_flag ACF,
1925: msic.ato_forecast_control AFC
1926: FROM mtl_system_items msic,
1927: mtl_system_items msia,
1928: bom_inventory_comps_interface ici
1929: WHERE process_flag = 2
1930: AND transaction_type = G_Insert

Line 1927: mtl_system_items msia,

1923: msic.replenish_to_order_flag RTOFC,
1924: msia.atp_components_flag ACF,
1925: msic.ato_forecast_control AFC
1926: FROM mtl_system_items msic,
1927: mtl_system_items msia,
1928: bom_inventory_comps_interface ici
1929: WHERE process_flag = 2
1930: AND transaction_type = G_Insert
1931: AND (UPPER(ici.interface_entity_type) = 'BILL'

Line 1983: FROM mtl_system_items msic,

1979: msia.replenish_to_order_flag RTOF,
1980: msic.replenish_to_order_flag RTOFC,
1981: msia.atp_components_flag ACF,
1982: msic.ato_forecast_control AFC
1983: FROM mtl_system_items msic,
1984: mtl_system_items msia,
1985: bom_inventory_comps_interface ici
1986: WHERE process_flag = 2
1987: AND transaction_type in (G_UPDATE, G_DELETE)

Line 1984: mtl_system_items msia,

1980: msic.replenish_to_order_flag RTOFC,
1981: msia.atp_components_flag ACF,
1982: msic.ato_forecast_control AFC
1983: FROM mtl_system_items msic,
1984: mtl_system_items msia,
1985: bom_inventory_comps_interface ici
1986: WHERE process_flag = 2
1987: AND transaction_type in (G_UPDATE, G_DELETE)
1988: AND (UPPER(ici.interface_entity_type) = 'BILL'

Line 2023: FROM mtl_system_items msic,

2019: msia.replenish_to_order_flag RTOF,
2020: msic.replenish_to_order_flag RTOFC,
2021: msia.atp_components_flag ACF,
2022: msic.ato_forecast_control AFC
2023: FROM mtl_system_items msic,
2024: mtl_system_items msia,
2025: bom_inventory_comps_interface ici
2026: WHERE ici.process_flag = 99
2027: AND ici.transaction_type = G_Update

Line 2024: mtl_system_items msia,

2020: msic.replenish_to_order_flag RTOFC,
2021: msia.atp_components_flag ACF,
2022: msic.ato_forecast_control AFC
2023: FROM mtl_system_items msic,
2024: mtl_system_items msia,
2025: bom_inventory_comps_interface ici
2026: WHERE ici.process_flag = 99
2027: AND ici.transaction_type = G_Update
2028: AND (UPPER(ici.interface_entity_type) = 'BILL'

Line 2953: FROM mtl_system_items

2949:
2950: SELECT inventory_asset_flag,restrict_subinventories_code,
2951: restrict_locators_code, location_control_code
2952: INTO inv_asst, r_subinv, r_loc, loc_ctl
2953: FROM mtl_system_items
2954: WHERE inventory_item_id = c3rec.CII
2955: AND organization_id = c3rec.OI;
2956: /*
2957: ** If item locator control is null, set to 1 (no loc control)

Line 3541: FROM mtl_system_items msi,

3537: stmt_num := 4.2;
3538: DECLARE
3539: CURSOR GetBOMItemType IS
3540: SELECT bom_item_type, assembly_item_id
3541: FROM mtl_system_items msi,
3542: bom_bill_of_materials bom
3543: WHERE msi.organization_id = bom.organization_id
3544: AND msi.inventory_item_id = bom.assembly_item_id
3545: AND bom.bill_sequence_id = c1rec.BSI;

Line 3613: FROM mtl_system_items

3609: stmt_num := 4.3;
3610: DECLARE
3611: CURSOR ItemIsValid IS
3612: SELECT inventory_item_id
3613: FROM mtl_system_items
3614: WHERE organization_id = c1rec.OI
3615: AND inventory_item_id = c1rec.CII
3616: AND bom_enabled_flag = 'Y'
3617: AND eng_item_flag = 'N'

Line 3703: FROM mtl_system_items msi

3699: WHERE bbom.common_bill_sequence_id = c1rec.BSI
3700: AND bbom.organization_id <> bbom.common_organization_id
3701: AND not exists
3702: (SELECT null
3703: FROM mtl_system_items msi
3704: WHERE msi.organization_id = bbom.organization_id
3705: AND msi.inventory_item_id = c1rec.CII
3706: AND msi.bom_enabled_flag = 'Y'
3707: AND ((bbom.assembly_type = 2)

Line 4143: FROM mtl_system_items

4139:
4140: SELECT inventory_asset_flag,restrict_subinventories_code,
4141: restrict_locators_code, location_control_code
4142: INTO inv_asst, r_subinv, r_loc, loc_ctl
4143: FROM mtl_system_items
4144: WHERE inventory_item_id = c1rec.CII
4145: AND organization_id = c1rec.OI;
4146: /*
4147: ** If item locator control is null, set to 1 (no loc control)

Line 4597: mtl_system_items msi1,

4593: bom.assembly_item_id AII,
4594: bic.operation_lead_time_percent OLTP --1851537
4595: FROM
4596: bom_bill_of_materials bom,
4597: mtl_system_items msi1,
4598: mtl_system_items msi2,
4599: bom_inventory_comps_interface bic
4600: WHERE bic.process_flag = 4
4601: AND bic.transaction_type = G_Insert

Line 4598: mtl_system_items msi2,

4594: bic.operation_lead_time_percent OLTP --1851537
4595: FROM
4596: bom_bill_of_materials bom,
4597: mtl_system_items msi1,
4598: mtl_system_items msi2,
4599: bom_inventory_comps_interface bic
4600: WHERE bic.process_flag = 4
4601: AND bic.transaction_type = G_Insert
4602: AND rownum < G_rows_to_commit

Line 4650: FROM mtl_system_items msi,

4646: bic.assembly_item_id AII, bic.alternate_bom_designator ABD,
4647: bic.component_sequence_id CSI, bic.transaction_id TI,
4648: msi.bom_item_type BIT, msic.bom_item_type BITC,
4649: bic.component_item_id CII
4650: FROM mtl_system_items msi,
4651: mtl_system_items msic,
4652: bom_inventory_comps_interface bic
4653: WHERE bic.process_flag = 4
4654: AND bic.transaction_type = G_DELETE

Line 4651: mtl_system_items msic,

4647: bic.component_sequence_id CSI, bic.transaction_id TI,
4648: msi.bom_item_type BIT, msic.bom_item_type BITC,
4649: bic.component_item_id CII
4650: FROM mtl_system_items msi,
4651: mtl_system_items msic,
4652: bom_inventory_comps_interface bic
4653: WHERE bic.process_flag = 4
4654: AND bic.transaction_type = G_DELETE
4655: AND (UPPER(bic.interface_entity_type) = 'BILL'

Line 4789: ** in mtl_system_items.

4785: c0rec.SS,
4786: c0rec.CBIT);
4787: /*
4788: ** If product family member is added, need to update PRODUCT_FAMILY_ID
4789: ** in mtl_system_items.
4790: */
4791: IF (c0rec.BIT = G_ProductFamily) THEN
4792: BEGIN
4793: UPDATE mtl_system_items

Line 4793: UPDATE mtl_system_items

4789: ** in mtl_system_items.
4790: */
4791: IF (c0rec.BIT = G_ProductFamily) THEN
4792: BEGIN
4793: UPDATE mtl_system_items
4794: SET product_family_item_id = c0rec.AII
4795: WHERE inventory_item_id = c0rec.CII
4796: AND organization_id = c0rec.OI;
4797: END;

Line 4912: UPDATE mtl_system_items

4908: AND component_item_id = c2rec.CII
4909: AND rownum = 1;
4910: EXCEPTION
4911: WHEN no_data_found THEN
4912: UPDATE mtl_system_items
4913: SET product_family_item_id = null
4914: WHERE inventory_item_id = c2rec.CII
4915: AND organization_id = c2rec.OI;
4916: END;