APPS.BOM_COPY_BILL dependencies on EGO_MINOR_REVISIONS

Line 451: FROM ego_minor_revisions

447: l_minor_rev_id NUMBER;
448: BEGIN
449: SELECT NVL (MAX (minor_revision_id), 0)
450: INTO l_minor_rev_id
451: FROM ego_minor_revisions
452: WHERE obj_name = 'EGO_ITEM'
453: AND pk1_value = p_item_id
454: AND NVL (pk2_value, '-1') = NVL (p_org_id, '-1')
455: AND NVL (pk3_value, '-1') = NVL (p_revision_id, '-1');

Line 792: FROM ego_minor_revisions

788: p_pk3_value IN VARCHAR2
789: )
790: IS
791: SELECT NVL (MAX (minor_revision_id), 0) minor_revision_id
792: FROM ego_minor_revisions
793: WHERE obj_name = 'EGO_ITEM'
794: AND pk1_value = p_pk1_value
795: AND NVL (pk2_value, '-1') = NVL (p_pk2_value, '-1')
796: AND NVL (pk3_value, '-1') = NVL (p_pk3_value, '-1');

Line 818: FROM ego_minor_revisions

814: maxr.minor_rev_id
815: ) mrev_code
816: FROM mtl_item_revisions_b r,
817: (SELECT NVL (MAX (minor_revision_id), 0) minor_rev_id
818: FROM ego_minor_revisions
819: WHERE obj_name = 'EGO_ITEM' --p_obj_name
820: AND pk1_value = p_pk1_value
821: AND NVL (pk2_value, '-1') = NVL (p_pk2_value, '-1')
822: AND NVL (pk3_value, '-1') =

Line 7320: FROM ego_minor_revisions

7316: p_pk3_value IN VARCHAR2
7317: )
7318: IS
7319: SELECT NVL (MAX (minor_revision_id), 0) minor_revision_id
7320: FROM ego_minor_revisions
7321: WHERE obj_name = 'EGO_ITEM'
7322: AND pk1_value = p_pk1_value
7323: AND NVL (pk2_value, '-1') = NVL (p_pk2_value, '-1')
7324: AND NVL (pk3_value, '-1') = NVL (p_pk3_value, '-1');