DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on MTL_SYSTEM_ITEMS_KFV

Line 495: mtl_system_items_kfv it

491: SELECT
492: bic.component_sequence_id
493: FROM
494: bom_inventory_components bic,
495: mtl_system_items_kfv it
496: WHERE
497: bic.bill_sequence_id = p_from_sequence_id
498: AND bic.component_item_id = it.inventory_item_id
499: AND it.organization_id = p_reference_org_id

Line 509: mtl_system_items_kfv it

505: sc.substitute_component_id,
506: it.concatenated_segments substitute_component_name
507: FROM
508: bom_substitute_components sc,
509: mtl_system_items_kfv it
510: WHERE
511: sc.substitute_component_id = it.inventory_item_id
512: AND it.organization_id = p_reference_org_id
513: AND sc.component_sequence_id = p_component_sequence_id

Line 574: mtl_system_items_kfv it

570: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.row_identifier ) row_identifier
571: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.program_id) program_id
572: FROM
573: bom_substitute_components sc,
574: mtl_system_items_kfv it
575: WHERE
576: sc.substitute_component_id = it.inventory_item_id AND
577: it.organization_id = p_reference_org_id AND
578: it.concatenated_segments = p_substitute_component_name AND

Line 773: mtl_system_items_kfv it

769: SELECT
770: bic.component_sequence_id
771: FROM
772: bom_inventory_components bic,
773: mtl_system_items_kfv it
774: WHERE
775: bic.bill_sequence_id = p_from_sequence_id
776: AND bic.component_item_id = it.inventory_item_id
777: AND it.organization_id = p_reference_org_id

Line 1048: mtl_system_items_kfv msi

1044: msi.concatenated_segments component_item_name,
1045: bic.component_item_id,
1046: bic.operation_seq_num
1047: FROM bom_inventory_components bic,
1048: mtl_system_items_kfv msi
1049: WHERE bic.bill_sequence_id = p_from_sequence_id
1050: AND bic.component_item_id = msi.inventory_item_id
1051: AND bic.component_item_id <> p_to_item_id
1052: AND NVL (bic.eco_for_production, 2) = 2

Line 1222: mtl_system_items_kfv it

1218: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.new_routing_revision) new_routing_revision
1219: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.return_status) return_status
1220: FROM
1221: bom_inventory_components bic,
1222: mtl_system_items_kfv it
1223: WHERE
1224: bic.component_item_id = it.inventory_item_id AND
1225: it.organization_id = p_reference_org_id AND
1226: it.concatenated_segments = p_component_item_name AND

Line 1524: mtl_system_items_kfv it,

1520: INTO
1521: l_Count
1522: FROM
1523: bom_bill_of_materials bb,
1524: mtl_system_items_kfv it,
1525: mtl_parameters mp
1526: WHERE
1527: bb.assembly_item_id = it.inventory_item_id AND
1528: it.organization_id = bb.organization_id AND

Line 1566: mtl_system_items_kfv msi,

1562:
1563: SELECT COUNT(1) INTO l_Count
1564: FROM
1565: eng_revised_items eri,
1566: mtl_system_items_kfv msi,
1567: mtl_parameters mp
1568: WHERE
1569: eri.revised_item_id = msi.inventory_item_id AND
1570: msi.organization_id = eri.organization_id AND

Line 1689: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;

1685: l_config_view_scope VARCHAR2(30) := 'ALL';
1686: l_config_impl_scope VARCHAR2(30) := 'ALL';
1687: l_return_status VARCHAR2(10);
1688: l_msg_Count NUMBER;
1689: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;
1690: l_reference_org_code mtl_parameters.organization_code%TYPE;
1691: l_as_of_date DATE;
1692: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;
1693: l_output_status inv_ebi_output_status;

Line 1745: mtl_system_items_kfv

1741: concatenated_segments
1742: INTO
1743: l_reference_item_num
1744: FROM
1745: mtl_system_items_kfv
1746: WHERE
1747: inventory_item_id = l_from_item_id AND
1748: organization_id = l_from_org_id;
1749: END IF;

Line 2516: FROM mtl_system_items_kfv

2512: IF(get_assign_item = FND_API.g_true ) THEN
2513: IF(INV_EBI_UTIL.is_pim_installed) THEN
2514: SELECT item_catalog_group_id, approval_status
2515: INTO l_item_catalog_group_id, l_approval_status
2516: FROM mtl_system_items_kfv
2517: WHERE organization_id = l_master_org
2518: AND concatenated_segments = p_item_name;
2519: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'
2520: THEN

Line 2569: mtl_system_items_kfv msi

2565: --To check if master orgs current reviison is already there in context org
2566: SELECT COUNT(1) INTO l_count
2567: FROM
2568: mtl_item_revisions_b mir,
2569: mtl_system_items_kfv msi
2570: WHERE
2571: mir.organization_id = msi.organization_id AND
2572: msi.organization_id = p_organization_id AND
2573: mir.inventory_item_id = msi.inventory_item_id AND

Line 2767: l_subst_comp_name mtl_system_items_kfv.concatenated_segments%TYPE;

2763: l_organization_id NUMBER;
2764: l_component_item_name VARCHAR2(240);
2765: l_master_org NUMBER;
2766: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
2767: l_subst_comp_name mtl_system_items_kfv.concatenated_segments%TYPE;
2768: l_return_status VARCHAR2(10);
2769: l_msg_count NUMBER;
2770: l_output_status inv_ebi_output_status;
2771: l_status_type NUMBER;

Line 3417: mtl_system_items_kfv msi

3413: msi.concatenated_segments component_item_name ,
3414: bic.component_item_id
3415: FROM
3416: bom_inventory_components bic,
3417: mtl_system_items_kfv msi
3418: WHERE
3419: bic.bill_sequence_id = p_src_bill_sequence_id AND
3420: bic.component_item_id = msi.inventory_item_id AND
3421: msi.organization_id = p_src_organization_id AND

Line 3425: FROM mtl_system_items_kfv s

3421: msi.organization_id = p_src_organization_id AND
3422: NVL(bic.disable_date, sysdate + 1) >= sysdate AND
3423: NOT EXISTS
3424: ( SELECT 'x'
3425: FROM mtl_system_items_kfv s
3426: WHERE s.organization_id = p_organization_id
3427: AND s.inventory_item_id = bic.component_item_id
3428: AND ((p_assy_type = 1 AND s.eng_item_flag = 'N')
3429: OR (p_assy_type = 2)

Line 3487: mtl_system_items_kfv msi

3483: msi.concatenated_segments sub_comp_item_name ,
3484: bsc.substitute_component_id
3485: FROM bom_inventory_components bic,
3486: bom_substitute_components bsc,
3487: mtl_system_items_kfv msi
3488: WHERE bic.bill_sequence_id = p_src_bill_sequence_id
3489: AND bic.component_sequence_id = bsc.component_sequence_id
3490: AND bsc.substitute_component_id = msi.inventory_item_id
3491: AND msi.organization_id = p_src_organization_id