DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on ENG_CHANGE_POLICIES_V

Line 338: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb

334:
335: SELECT
336: ecp.policy_char_value INTO l_change_policy_char_val
337: FROM
338: MTL_SYSTEM_ITEMS ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP, Bom_Structures_b bsb
339: WHERE
340: ecp.policy_object_pk1_value =
341: (SELECT TO_CHAR(ic.item_catalog_group_id)
342: FROM mtl_item_catalog_groups_b ic

Line 2944: ENG_CHANGE_POLICIES_V ECP

2940: AND bet.component_item_id = msi.INVENTORY_ITEM_ID AND
2941: bet.organization_id = msi.ORGANIZATION_ID AND
2942: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))
2943: AND (mirb.current_phase_id IS NOT NULL OR msi.current_phase_id IS NOT NULL)) ITEM_DTLS,
2944: ENG_CHANGE_POLICIES_V ECP
2945: WHERE --ecp.policy_object_pk1_value = item_dtls.item_catalog_group_id
2946: ecp.policy_object_pk1_value =
2947: (SELECT TO_CHAR(ic.item_catalog_group_id)
2948: FROM mtl_item_catalog_groups_b ic