[Home] [Help]
394: and mirb.ORGANIZATION_ID(+)= msi.ORGANIZATION_ID
395: and mirb.revision_id(+) = c2.pk3_value
396: and msi.INVENTORY_ITEM_ID = c2.pk2_value
397: and msi.ORGANIZATION_ID = c2.pk1_value) ITEM_DTLS,
398: ENG_CHANGE_POLICIES_V ECP
399: WHERE
400: ecp.policy_object_pk1_value =
401: (SELECT TO_CHAR(ic.item_catalog_group_id)
402: FROM mtl_item_catalog_groups_b ic