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

Line 377: Verifies in MTL_SYSTEM_ITEMS if assembly item exists.

373: /* NAME
374: bmvassyid_verify_assembly_id - verify assembly item id exists in item
375: master
376: DESCRIPTION
377: Verifies in MTL_SYSTEM_ITEMS if assembly item exists.
378:
379: REQUIRES
380: org_id organization_id
381: assy_id assembly_item_id

Line 400: from mtl_system_items

396: cnt NUMBER := 0;
397: BEGIN
398: select inventory_item_id
399: into cnt
400: from mtl_system_items
401: where organization_id = org_id
402: and inventory_item_id = assy_id;
403: return(0);
404: EXCEPTION

Line 669: from mtl_system_items

665: cnt NUMBER := 0;
666: BEGIN
667: select 1
668: into cnt
669: from mtl_system_items
670: where organization_id = org_id
671: and inventory_item_id = assy_id
672: and bom_enabled_flag = 'Y'
673: and ((assy_type = 2)

Line 829: from mtl_system_items

825: /* Get item attributes for the bill */
826: select bom_item_type, base_item_id, replenish_to_order_flag,
827: pick_components_flag
828: into bit, base_id, ato, pto
829: from mtl_system_items
830: where inventory_item_id = item_id
831: and organization_id = org_id;
832:
833: select count(*)

Line 839: FROM MTL_SYSTEM_ITEMS S

835: from bom_inventory_components bic
836: where bic.bill_sequence_id = cmn_bom_id
837: and NOT EXISTS
838: (SELECT 'x'
839: FROM MTL_SYSTEM_ITEMS S
840: WHERE S.ORGANIZATION_ID = org_id
841: AND S.INVENTORY_ITEM_ID = bic.COMPONENT_ITEM_ID
842: AND ((bom_type = 1
843: AND S.ENG_ITEM_FLAG = 'N')

Line 890: FROM MTL_SYSTEM_ITEMS S

886: where bill_sequence_id = cmn_bom_id
887: and process_flag in (2, 4)
888: and NOT EXISTS
889: (SELECT 'x'
890: FROM MTL_SYSTEM_ITEMS S
891: WHERE S.ORGANIZATION_ID = org_id
892: AND S.INVENTORY_ITEM_ID = bic.COMPONENT_ITEM_ID
893: AND ((bom_type = 1
894: AND S.ENG_ITEM_FLAG = 'N')

Line 947: from mtl_system_items msi1, mtl_system_items msi2

943: where bic.bill_sequence_id = cmn_bom_id
944: and bic.component_sequence_id = bsc.component_sequence_id
945: and bsc.substitute_component_id not in
946: (select msi1.inventory_item_id
947: from mtl_system_items msi1, mtl_system_items msi2
948: where msi1.organization_id = org_id
949: and msi1.inventory_item_id = bsc.substitute_component_id
950: and msi2.organization_id = cmn_org_id
951: and msi2.inventory_item_id = msi1.inventory_item_id);

Line 966: from mtl_system_items msi1, mtl_system_items msi2

962: and bsc.process_flag in (2, 4)
963: and bic.component_sequence_id = bsc.component_sequence_id
964: and bsc.substitute_component_id not in
965: (select msi1.inventory_item_id
966: from mtl_system_items msi1, mtl_system_items msi2
967: where msi1.organization_id = org_id
968: and msi1.inventory_item_id = bsc.substitute_component_id
969: and msi2.organization_id = cmn_org_id
970: and msi2.inventory_item_id = msi1.inventory_item_id);

Line 984: from mtl_system_items msi1, mtl_system_items msi2

980: and bsc.process_flag in (2, 4)
981: and bic.component_sequence_id = bsc.component_sequence_id
982: and bsc.substitute_component_id not in
983: (select msi1.inventory_item_id
984: from mtl_system_items msi1, mtl_system_items msi2
985: where msi1.organization_id = org_id
986: and msi1.inventory_item_id = bsc.substitute_component_id
987: and msi2.organization_id = cmn_org_id
988: and msi2.inventory_item_id = msi1.inventory_item_id);

Line 1004: from mtl_system_items msi1, mtl_system_items msi2

1000: */
1001: begin
1002: select 1
1003: into cnt
1004: from mtl_system_items msi1, mtl_system_items msi2
1005: where msi1.organization_id = org_id
1006: and msi1.inventory_item_id = item_id
1007: and msi2.organization_id = cmn_org_id
1008: and msi2.inventory_item_id = cmn_item_id

Line 1109: from mtl_system_items msic,

1105: msia.replenish_to_order_flag RTOF,
1106: msic.replenish_to_order_flag RTOFC,
1107: msia.atp_components_flag ACF,
1108: msic.ato_forecast_control AFC
1109: from mtl_system_items msic,
1110: mtl_system_items msia,
1111: bom_inventory_comps_interface ici
1112: where process_flag = 2
1113: and msic.organization_id = ici.organization_id

Line 1110: mtl_system_items msia,

1106: msic.replenish_to_order_flag RTOFC,
1107: msia.atp_components_flag ACF,
1108: msic.ato_forecast_control AFC
1109: from mtl_system_items msic,
1110: mtl_system_items msia,
1111: bom_inventory_comps_interface ici
1112: where process_flag = 2
1113: and msic.organization_id = ici.organization_id
1114: and msia.organization_id = ici.organization_id

Line 1672: from mtl_system_items

1668:
1669: select inventory_asset_flag,restrict_subinventories_code,
1670: restrict_locators_code, location_control_code
1671: into inv_asst, r_subinv, r_loc, loc_ctl
1672: from mtl_system_items
1673: where inventory_item_id = c1rec.CII
1674: and organization_id = c1rec.OI;
1675: /*
1676: ** if item locator control is null, set to 1 (no loc control)

Line 2076: from mtl_system_items assy, mtl_system_items comp

2072:
2073: BEGIN
2074: select 1
2075: into dummy
2076: from mtl_system_items assy, mtl_system_items comp
2077: where comp.organization_id = org_id
2078: and assy.organization_id = org_id
2079: and comp.inventory_item_id = cmp_id
2080: and assy.inventory_item_id = assy_id

Line 2121: from mtl_system_items assy, mtl_system_items comp

2117:
2118: begin
2119: select 1
2120: into dummy
2121: from mtl_system_items assy, mtl_system_items comp
2122: where comp.organization_id = org_id
2123: and assy.organization_id = org_id
2124: and comp.inventory_item_id = cmp_id
2125: and assy.inventory_item_id = assy_id

Line 2179: from mtl_system_items

2175:
2176: BEGIN
2177: select bom_item_type
2178: into dummy
2179: from mtl_system_items
2180: where organization_id = org_id
2181: and inventory_item_id = assy_id;
2182:
2183: if dummy = 3 and op_seq <> 1 then

Line 2714: from mtl_system_items msi

2710: <>
2711: NULL;
2712: select bom_item_type
2713: into dummy
2714: from mtl_system_items msi
2715: where msi.organization_id = org_id_dummy
2716: and msi.inventory_item_id = assy_id_dummy;
2717:
2718: if (dummy = 3) then

Line 3113: from mtl_system_items msi

3109: <>
3110: NULL;
3111: select bom_item_type
3112: into dummy
3113: from mtl_system_items msi
3114: where msi.organization_id = org_id_dummy
3115: and msi.inventory_item_id = assy_id_dummy;
3116:
3117: if (dummy = 3) then

Line 3172: from mtl_system_items b

3168: from bom_sub_comps_interface a
3169: where transaction_id = c1rec.TI
3170: and process_flag <> 3 and process_flag <> 7
3171: and not exists (select 'items exist'
3172: from mtl_system_items b
3173: where b.organization_id = org_id_dummy
3174: and b.inventory_item_id = a.substitute_component_id);
3175:
3176: if (dummy <> 0) then

Line 3273: from mtl_system_items msi

3269: into dummy
3270: from bom_sub_comps_interface bsc
3271: where bsc.transaction_id = c1rec.TI
3272: and not exists (select 'x'
3273: from mtl_system_items msi
3274: where organization_id = org_id_dummy
3275: and inventory_item_id = bsc.substitute_component_id
3276: and bom_enabled_flag = 'Y'
3277: and bom_item_type = 4