DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on ENG_CHANGE_POLICIES_V

Line 326: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb

322:
323: SELECT
324: ecp.policy_char_value INTO l_change_policy_char_val
325: FROM
326: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
327: WHERE
328: ecp.policy_object_pk1_value =
329: (SELECT TO_CHAR(ic.item_catalog_group_id)
330: FROM mtl_item_catalog_groups_b ic

Line 2854: ENG_CHANGE_POLICIES_V ECP

2850: AND bet.component_item_id = msi.INVENTORY_ITEM_ID AND
2851: bet.organization_id = msi.ORGANIZATION_ID AND
2852: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))
2853: AND (mirb.current_phase_id IS NOT NULL OR msi.current_phase_id IS NOT NULL)) ITEM_DTLS,
2854: ENG_CHANGE_POLICIES_V ECP
2855: WHERE --ecp.policy_object_pk1_value = item_dtls.item_catalog_group_id
2856: ecp.policy_object_pk1_value =
2857: (SELECT TO_CHAR(ic.item_catalog_group_id)
2858: FROM mtl_item_catalog_groups_b ic