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 796: FROM ego_minor_revisions

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

Line 822: FROM ego_minor_revisions

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

Line 7420: FROM ego_minor_revisions

7416: p_pk3_value IN VARCHAR2
7417: )
7418: IS
7419: SELECT NVL (MAX (minor_revision_id), 0) minor_revision_id
7420: FROM ego_minor_revisions
7421: WHERE obj_name = 'EGO_ITEM'
7422: AND pk1_value = p_pk1_value
7423: AND NVL (pk2_value, '-1') = NVL (p_pk2_value, '-1')
7424: AND NVL (pk3_value, '-1') = NVL (p_pk3_value, '-1');