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 2514: FROM mtl_system_items mtl

2510: UPDATE bom_cto_order_lines_gt bcol_gt
2511: SET config_creation =
2512: --used round to be consistent with can_configuration code
2513: ( SELECT nvl(mtl.config_orgs,1)--3555026
2514: FROM mtl_system_items mtl
2515: WHERE mtl.inventory_item_id = bcol_gt.inventory_item_id
2516: AND mtl.organization_id = bcol_gt.validation_org--3555026
2517: )
2518: --to filter out ato item order lines

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

3142:
3143: END Insert_into_bcol_gt;
3144:
3145:
3146: -- This procedure will get the Match_attribute from mtl_system_items_b
3147: -- Will process those flags.
3148: --Eg:
3149: -- Model levels Match_ttribute perform_match
3150: -- (from Item form) (calculated)

Line 3486: FROM mtl_system_items_b mtl

3482:
3483: UPDATE /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N5) */ bom_cto_order_lines_gt bcol
3484: SET bcol.perform_match=
3485: (SELECT config_match
3486: FROM mtl_system_items_b mtl
3487: WHERE mtl.inventory_item_id = bcol.inventory_item_id
3488:
3489: AND mtl.organization_id = bcol.validation_org --reuse_revert
3490: --3555026