APPS.BOM_EXPLODER_PUB dependencies on EGO_MINOR_REVISIONS

Line 1162: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions

1158: CURSOR getCurrentMinorRev (p_obj_name IN VARCHAR2,
1159: p_pk1_value IN VARCHAR2,
1160: p_pk2_value IN VARCHAR2,
1161: p_pk3_value IN VARCHAR2) IS
1162: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions
1163: WHERE obj_name = p_obj_name AND
1164: pk1_value = p_pk1_value AND
1165: nvl(pk2_value,'-1') = nvl(p_pk2_value,'-1') AND
1166: nvl(pk3_value,'-1') = nvl(p_pk3_value,'-1');

Line 2722: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions

2718: CURSOR getCurrentMinorRev (p_obj_name IN VARCHAR2,
2719: p_pk1_value IN VARCHAR2,
2720: p_pk2_value IN VARCHAR2,
2721: p_pk3_value IN VARCHAR2) IS
2722: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions
2723: WHERE obj_name = p_obj_name AND
2724: pk1_value = p_pk1_value AND
2725: nvl(pk2_value,'-1') = nvl(p_pk2_value,'-1') AND
2726: nvl(pk3_value,'-1') = nvl(p_pk3_value,'-1');

Line 2729: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions

2725: nvl(pk2_value,'-1') = nvl(p_pk2_value,'-1') AND
2726: nvl(pk3_value,'-1') = nvl(p_pk3_value,'-1');
2727:
2728: CURSOR getCurrentMinorRevForItemRev (p_item_rev_id IN NUMBER) IS
2729: SELECT nvl(max(minor_revision_id),0) minor_revision_id FROM ego_minor_revisions
2730: WHERE obj_name = 'EGO_ITEM_REVISION'
2731: AND pk3_value = p_item_rev_id;
2732:
2733: CURSOR getEndItemMinorRevCode (p_revision_id IN NUMBER,