APPS.CTO_MATCH_CONFIG dependencies on MTL_SYSTEM_ITEMS

Line 821: from mtl_system_items msi,

817: and bac1.component_item_id = col1.inventory_item_id
818: and bac1.config_item_id = bact1.config_item_id
819: and not exists (
820: select 'Config Item is not active in atleast one orgn'
821: from mtl_system_items msi,
822: bom_parameters bp
823: where msi.organization_id = bp.organization_id
824: and msi.inventory_item_id = bac1.config_item_id
825: and msi.inventory_item_status_code = nvl(bp.bom_delete_status_code,'NULL')

Line 1032: mtl_system_items msi

1028: BEGIN
1029: SELECT 'Y'
1030: INTO l_ato_flag
1031: FROM bom_cto_order_lines bcol,
1032: mtl_system_items msi
1033: WHERE bcol.line_id = p_model_line_id
1034: AND bcol.config_item_id = msi.inventory_item_id
1035: AND msi.replenish_to_order_flag = 'Y'
1036: AND rownum =1;

Line 2549: FROM mtl_system_items mtl

2545: UPDATE bom_cto_order_lines_gt bcol_gt
2546: SET config_creation =
2547: --used round to be consistent with can_configuration code
2548: ( SELECT nvl(mtl.config_orgs,1)--3555026
2549: FROM mtl_system_items mtl
2550: WHERE mtl.inventory_item_id = bcol_gt.inventory_item_id
2551: AND mtl.organization_id = bcol_gt.validation_org--3555026
2552: )
2553: --to filter out ato item order lines

Line 3181: -- This procedure will get the Match_attribute from mtl_system_items_b

3177:
3178: END Insert_into_bcol_gt;
3179:
3180:
3181: -- This procedure will get the Match_attribute from mtl_system_items_b
3182: -- Will process those flags.
3183: --Eg:
3184: -- Model levels Match_ttribute perform_match
3185: -- (from Item form) (calculated)

Line 3521: FROM mtl_system_items_b mtl

3517:
3518: UPDATE /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N5) */ bom_cto_order_lines_gt bcol
3519: SET bcol.perform_match=
3520: (SELECT config_match
3521: FROM mtl_system_items_b mtl
3522: WHERE mtl.inventory_item_id = bcol.inventory_item_id
3523:
3524: AND mtl.organization_id = bcol.validation_org --reuse_revert
3525: --3555026