DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_CHANGE_POLICIES_V

Line 727: AND msi.ORGANIZATION_ID = mir.ORGANIZATION_ID) ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP

723: WHERE mir.INVENTORY_ITEM_ID = p_inventory_item_id
724: AND mir.ORGANIZATION_ID = p_organization_id
725: AND mir.revision_id = p_revision_id
726: AND msi.INVENTORY_ITEM_ID = mir.INVENTORY_ITEM_ID
727: AND msi.ORGANIZATION_ID = mir.ORGANIZATION_ID) ITEM_DTLS, ENG_CHANGE_POLICIES_V ECP
728: WHERE ecp.policy_object_pk1_value =
729: (SELECT TO_CHAR(ic.item_catalog_group_id)
730: FROM mtl_item_catalog_groups_b ic
731: WHERE EXISTS