eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_EXPLODER_PUB dependencies on MTL_ITEM_REVISIONS_B

Line 152: SELECT 'Y' INTO l_result FROM mtl_item_revisions_b WHERE inventory_item_id = p_inventory_item_id AND

148: IF p_revision_id IS NULL
149: THEN
150: Return 'N';
151: END IF;
152: SELECT 'Y' INTO l_result FROM mtl_item_revisions_b WHERE inventory_item_id = p_inventory_item_id AND
153: organization_id = p_organization_id AND revision_id = p_revision_id;
154: Return l_result;
155: EXCEPTION WHEN NO_DATA_FOUND
156: THEN

Line 167: SELECT revision INTO l_revision FROM mtl_item_revisions_b WHERE revision_id = p_revision_id;

163: IF p_revision_id IS NULL
164: THEN
165: Return null;
166: END IF;
167: SELECT revision INTO l_revision FROM mtl_item_revisions_b WHERE revision_id = p_revision_id;
168: Return l_revision;
169: EXCEPTION WHEN NO_DATA_FOUND
170: THEN
171: Return null;

Line 178: SELECT revision, revision_id,revision_label FROM mtl_item_revisions_b WHERE

174: FUNCTION Get_Current_RevisionDetails( p_inventory_item_id IN NUMBER,
175: p_organization_id IN NUMBER,
176: p_effectivity_date IN DATE) RETURN VARCHAR2 IS
177: CURSOR c1 IS
178: SELECT revision, revision_id,revision_label FROM mtl_item_revisions_b WHERE
179: inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id AND
180: effectivity_date <= p_effectivity_date
181: AND ((BOM_GLOBALS.get_show_Impl_comps_only = 'Y' AND implementation_date IS NOT NULL) OR BOM_GLOBALS.get_show_Impl_comps_only = 'N') -- added for Bug 7242865
182: ORDER BY effectivity_date DESC;

Line 950: FROM mtl_item_revisions_b

946: AND BIC.DISABLE_DATE IS NULL
947: AND BIC.FROM_END_ITEM_REV_ID IS NOT NULL
948: AND
949: ( (BET.plan_level > 0 AND EXISTS (SELECT null
950: FROM mtl_item_revisions_b
951: WHERE inventory_item_id = BET.component_item_id AND
952: organization_id = BET.organization_id AND
953: revision_id = BIC.FROM_END_ITEM_REV_ID ))
954: OR

Line 955: EXISTS (SELECT null FROM mtl_item_revisions_b

951: WHERE inventory_item_id = BET.component_item_id AND
952: organization_id = BET.organization_id AND
953: revision_id = BIC.FROM_END_ITEM_REV_ID ))
954: OR
955: EXISTS (SELECT null FROM mtl_item_revisions_b
956: WHERE inventory_item_id = l_end_item_id AND
957: organization_id = l_end_item_org_id AND
958: revision_id = BIC.FROM_END_ITEM_REV_ID) )))
959: )

Line 974: FROM mtl_item_revisions_b

970: AND BIC.FROM_END_ITEM_REV_ID IS NOT NULL
971: AND
972: ( (l_end_item_minor_rev_code <= (SELECT concat(to_char(decode(BIC.TO_END_ITEM_REV_ID,null,to_date('9999-12-31','YYYY-MM-DD'),effectivity_date),'yyyymmddhh24miss'),
973: to_char(nvl(BIC.to_end_item_minor_rev_id,9999999999999999)))
974: FROM mtl_item_revisions_b
975: WHERE inventory_item_id = l_end_item_id AND
976: organization_id = l_end_item_org_id AND
977: revision_id = nvl(BIC.TO_END_ITEM_REV_ID,BIC.FROM_END_ITEM_REV_ID)))
978: OR

Line 981: FROM mtl_item_revisions_b

977: revision_id = nvl(BIC.TO_END_ITEM_REV_ID,BIC.FROM_END_ITEM_REV_ID)))
978: OR
979: (BET.minor_revision_code <= (SELECT concat(to_char(decode(BIC.TO_END_ITEM_REV_ID,null,to_date('9999-12-31','YYYY-MM-DD'),effectivity_date),'yyyymmddhh24miss'),
980: to_char(nvl(BIC.to_end_item_minor_rev_id,9999999999999999)))
981: FROM mtl_item_revisions_b
982: WHERE inventory_item_id = BET.component_item_id AND
983: organization_id = BET.organization_id AND
984: revision_id = nvl(BIC.TO_END_ITEM_REV_ID,BIC.FROM_END_ITEM_REV_ID)))
985: )

Line 995: FROM mtl_item_revisions_b

991: AND
992: (
993: (l_end_item_minor_rev_code >= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),
994: to_char(nvl(BIC.from_end_item_minor_rev_id,0)))
995: FROM mtl_item_revisions_b
996: WHERE inventory_item_id = l_end_item_id AND
997: organization_id = l_end_item_org_id AND
998: revision_id = BIC.FROM_END_ITEM_REV_ID)
999: AND (BIC.to_end_item_rev_id IS NULL OR

Line 1002: FROM mtl_item_revisions_b

998: revision_id = BIC.FROM_END_ITEM_REV_ID)
999: AND (BIC.to_end_item_rev_id IS NULL OR
1000: l_end_item_minor_rev_code <= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),
1001: to_char(nvl(BIC.to_end_item_minor_rev_id,9999999999999999)))
1002: FROM mtl_item_revisions_b
1003: WHERE inventory_item_id = l_end_item_id AND
1004: organization_id = l_end_item_org_id AND
1005: revision_id = BIC.TO_END_ITEM_REV_ID) ))
1006:

Line 1011: FROM mtl_item_revisions_b

1007: OR
1008:
1009: (BET.minor_revision_code >= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),
1010: to_char(nvl(BIC.from_end_item_minor_rev_id,0)))
1011: FROM mtl_item_revisions_b
1012: WHERE inventory_item_id = BET.component_item_id AND
1013: organization_id = BET.organization_id AND
1014: revision_id = BIC.FROM_END_ITEM_REV_ID)
1015: AND (BIC.to_end_item_rev_id IS NULL OR

Line 1018: FROM mtl_item_revisions_b

1014: revision_id = BIC.FROM_END_ITEM_REV_ID)
1015: AND (BIC.to_end_item_rev_id IS NULL OR
1016: BET.minor_revision_code <= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),
1017: to_char(nvl(BIC.to_end_item_minor_rev_id,9999999999999999)))
1018: FROM mtl_item_revisions_b
1019: WHERE inventory_item_id = BET.component_item_id AND
1020: organization_id = BET.organization_id AND
1021: revision_id = BIC.TO_END_ITEM_REV_ID)) )
1022: )

Line 1078: FROM mtl_item_revisions_b WHERE revision_id = BIC.FROM_OBJECT_REVISION_ID)

1074: OR
1075: ( BET.OBJ_NAME IS NULL AND
1076: BET.minor_revision_code >= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),
1077: to_char(nvl(BIC.from_minor_revision_id,0)))
1078: FROM mtl_item_revisions_b WHERE revision_id = BIC.FROM_OBJECT_REVISION_ID)
1079: AND (BIC.to_object_revision_id IS NULL OR
1080: BET.minor_revision_code <= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),
1081: to_char(nvl(BIC.to_minor_revision_id,9999999999999999)))
1082: FROM mtl_item_revisions_b WHERE revision_id = BIC.TO_OBJECT_REVISION_ID))

Line 1082: FROM mtl_item_revisions_b WHERE revision_id = BIC.TO_OBJECT_REVISION_ID))

1078: FROM mtl_item_revisions_b WHERE revision_id = BIC.FROM_OBJECT_REVISION_ID)
1079: AND (BIC.to_object_revision_id IS NULL OR
1080: BET.minor_revision_code <= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),
1081: to_char(nvl(BIC.to_minor_revision_id,9999999999999999)))
1082: FROM mtl_item_revisions_b WHERE revision_id = BIC.TO_OBJECT_REVISION_ID))
1083: )
1084: )
1085: )
1086: )

Line 1155: SELECT revision_id, revision, revision_label FROM mtl_item_revisions_b WHERE revision_id = p_revision_id;

1151: total number;
1152:
1153: /*
1154: CURSOR getItemRevDetails (p_revision_id IN NUMBER) IS
1155: SELECT revision_id, revision, revision_label FROM mtl_item_revisions_b WHERE revision_id = p_revision_id;
1156: */
1157:
1158: CURSOR getCurrentMinorRev (p_obj_name IN VARCHAR2,
1159: p_pk1_value IN VARCHAR2,

Line 1170: SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(p_minor_rev_id)) mrev_code FROM mtl_item_revisions_b

1166: nvl(pk3_value,'-1') = nvl(p_pk3_value,'-1');
1167:
1168: CURSOR getCurrentMinorRevCode (p_revision_id IN NUMBER,
1169: p_minor_rev_id IN NUMBER) IS
1170: SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(p_minor_rev_id)) mrev_code FROM mtl_item_revisions_b
1171: WHERE revision_id = p_revision_id;
1172:
1173:
1174: CURSOR getItemRevision (p_inventory_item_id IN NUMBER,

Line 1179: FROM mtl_item_revisions_b MIR

1175: p_organization_id IN NUMBER,
1176: p_revision_date IN DATE,
1177: p_impl_flag IN NUMBER) IS
1178: SELECT revision,revision_label,revision_id
1179: FROM mtl_item_revisions_b MIR
1180: WHERE mir.inventory_item_id = p_inventory_item_id
1181: AND mir.organization_id = p_organization_id
1182: AND mir.effectivity_date <= p_revision_date
1183: AND (p_impl_flag = 2 OR (p_impl_flag = 1 AND mir.implementation_date IS NOT NULL) )

Line 1230: FROM Mtl_Item_Revisions_B rev2 , Mtl_Item_Revisions_B rev1

1226: NVL( MIN(rev2.Effectivity_Date - 1/(60*60*24)),
1227: GREATEST(TO_DATE('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'), reV1.Effectivity_Date)
1228: ) High_Date,
1229: rev1.Implementation_Date, rev1.Change_Notice, rev1.revision_label
1230: FROM Mtl_Item_Revisions_B rev2 , Mtl_Item_Revisions_B rev1
1231: WHERE rev1.revision_id = p_revision_id AND rev1.Organization_Id = rev2.Organization_Id(+)
1232: AND rev1.Inventory_Item_Id = rev2.Inventory_Item_Id(+) AND rev2.Effectivity_Date(+) > rev1.Effectivity_Date
1233: AND rev2.implementation_date (+) IS NOT NULL
1234: GROUP BY rev1.Organization_Id, rev1.Inventory_Item_Id, rev1.Revision_Id, rev1.Revision, rev1.Effectivity_Date,

Line 2705: rev1.implementation_date, rev1.change_notice FROM mtl_item_revisions_b rev2 , mtl_item_revisions_b rev1

2701: SELECT revision revision, revision_id revision_id FROM (
2702: SELECT rev1.organization_id , rev1.inventory_item_id , rev1.revision_id , rev1.revision ,
2703: rev1.effectivity_date , nvl(min(rev2.effectivity_date - 1/(60*60*24)),
2704: greatest(to_date('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'), reV1.effectivity_date)) high_date,
2705: rev1.implementation_date, rev1.change_notice FROM mtl_item_revisions_b rev2 , mtl_item_revisions_b rev1
2706: WHERE rev1.inventory_item_id = p_inventory_item_id AND rev1.organization_id = p_organization_id AND
2707: rev1.organization_id = rev2.organization_id(+) AND
2708: rev1.inventory_item_id = rev2.inventory_item_id(+) AND
2709: rev2.effectivity_date(+) > rev1.effectivity_date

Line 2715: SELECT inventory_item_id, organization_id, revision,effectivity_date FROM mtl_item_revisions_b

2711: rev1.revision , rev1.effectivity_date , rev1.implementation_date , rev1.change_notice)
2712: WHERE p_effective_date BETWEEN effectivity_date AND high_date;
2713:
2714: CURSOR getEndItemRev (p_item_revision_id IN NUMBER) IS
2715: SELECT inventory_item_id, organization_id, revision,effectivity_date FROM mtl_item_revisions_b
2716: WHERE revision_id = p_item_revision_id;
2717:
2718: CURSOR getCurrentMinorRev (p_obj_name IN VARCHAR2,
2719: p_pk1_value IN VARCHAR2,

Line 2735: SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(p_minor_rev_id)) mrev_code FROM mtl_item_revisions_b

2731: AND pk3_value = p_item_rev_id;
2732:
2733: CURSOR getEndItemMinorRevCode (p_revision_id IN NUMBER,
2734: p_minor_rev_id IN NUMBER) IS
2735: SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(p_minor_rev_id)) mrev_code FROM mtl_item_revisions_b
2736: WHERE revision_id = p_revision_id;
2737:
2738: CURSOR getPreferredStructure ( p_obj_name IN VARCHAR2,
2739: p_pk1_value IN VARCHAR2,

Line 2754: SELECT effectivity_date, revision_id, revision FROM mtl_item_revisions_b WHERE

2750: ORDER BY sort_order;
2751:
2752: CURSOR c_get_first_revision (p_inventory_item_id IN NUMBER,
2753: p_organization_id IN NUMBER) IS
2754: SELECT effectivity_date, revision_id, revision FROM mtl_item_revisions_b WHERE
2755: inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id AND
2756: effectivity_date = ( SELECT min(effectivity_date) FROM mtl_item_revisions_b
2757: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id );
2758:

Line 2756: effectivity_date = ( SELECT min(effectivity_date) FROM mtl_item_revisions_b

2752: CURSOR c_get_first_revision (p_inventory_item_id IN NUMBER,
2753: p_organization_id IN NUMBER) IS
2754: SELECT effectivity_date, revision_id, revision FROM mtl_item_revisions_b WHERE
2755: inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id AND
2756: effectivity_date = ( SELECT min(effectivity_date) FROM mtl_item_revisions_b
2757: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id );
2758:
2759: CURSOR c_Pkg_Structure_Type IS
2760: SELECT structure_type_id

Line 2766: mir.revision revision FROM bom_explosions_all bet, mtl_item_revisions_b mir

2762: WHERE structure_type_name = 'Packaging Hierarchy';
2763:
2764: CURSOR getComponentFixedRevisions (p_group_id IN NUMBER) IS
2765: SELECT bet.component_sequence_id, bet.component_item_revision_id revision_id,
2766: mir.revision revision FROM bom_explosions_all bet, mtl_item_revisions_b mir
2767: WHERE bet.group_id = p_group_id AND bet.plan_level <> 0 AND nvl(bet.component_item_revision_id,0) <> 0
2768: AND bet.component_item_revision_id = mir.revision_id;
2769:
2770: CURSOR getFixedRevDetails (p_group_id IN NUMBER) IS

Line 2792: FROM bom_explosions_all bet, Mtl_Item_Revisions_B rev2 , Mtl_Item_Revisions_B rev1

2788: NVL( MIN(rev2.Effectivity_Date - 1/(60*60*24)),
2789: GREATEST(TO_DATE('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'), reV1.Effectivity_Date)
2790: ) High_Date,
2791: rev1.Implementation_Date, rev1.Change_Notice, rev1.revision_label
2792: FROM bom_explosions_all bet, Mtl_Item_Revisions_B rev2 , Mtl_Item_Revisions_B rev1
2793: WHERE bet.group_id = p_group_id AND bet.component_item_revision_id IS NOT NULL AND
2794: rev1.revision_id = bet.component_item_revision_id AND rev1.Organization_Id = rev2.Organization_Id(+)
2795: AND rev1.Inventory_Item_Id = rev2.Inventory_Item_Id(+) AND rev2.Effectivity_Date(+) > rev1.Effectivity_Date
2796: AND rev2.implementation_date (+) IS NOT NULL

Line 2848: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2844: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2845: msi.item_catalog_group_id item_catalog_group_id,
2846: msi.inventory_item_id, msi.organization_id , mirb.revision_id,
2847: bet.component_sequence_id, bet.structure_type_id
2848: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2849: WHERE bet.group_id = p_group_id AND bet.comp_bill_seq_id IS NOT NULL
2850: AND bet.component_item_id = msi.INVENTORY_ITEM_ID AND
2851: bet.organization_id = msi.ORGANIZATION_ID AND
2852: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))

Line 3444: SELECT inventory_item_id, organization_id, revision INTO l_end_item_id, l_end_item_org_id,l_end_item_revision_code FROM mtl_item_revisions_b

3440: -- Get the end item information
3441: IF l_end_item_id IS NULL THEN
3442:
3443: BEGIN
3444: SELECT inventory_item_id, organization_id, revision INTO l_end_item_id, l_end_item_org_id,l_end_item_revision_code FROM mtl_item_revisions_b
3445: WHERE revision_id = l_end_item_revision_id;
3446: EXCEPTION WHEN OTHERS THEN
3447: --Dbms_Output.put_line('End item revision is not valid'||sqlerrm);
3448: raise parameter_error;

Line 4093: AND Get_Component_Revision(nvl(be.component_sequence_id,0)) >= (SELECT revision FROM mtl_item_revisions_b WHERE

4089: AND excl.from_revision_id IS NOT NULL --conditions to pickup only rev level exclusions
4090: AND excl.implementation_date IS NOT NULL -- do not pickup the pending exclusions
4091: AND excl.disable_date IS NULL -- do not pickup the disabled exclusions
4092: AND excl.acd_type = 1 -- pickup only the exclusion entries
4093: AND Get_Component_Revision(nvl(be.component_sequence_id,0)) >= (SELECT revision FROM mtl_item_revisions_b WHERE
4094: revision_id = excl.from_revision_id) AND
4095: ( excl.to_revision_id IS NULL OR
4096: Get_Component_Revision(nvl(be.component_sequence_id,0)) <= (SELECT revision FROM mtl_item_revisions_b WHERE
4097: revision_id = excl.to_revision_id));

Line 4096: Get_Component_Revision(nvl(be.component_sequence_id,0)) <= (SELECT revision FROM mtl_item_revisions_b WHERE

4092: AND excl.acd_type = 1 -- pickup only the exclusion entries
4093: AND Get_Component_Revision(nvl(be.component_sequence_id,0)) >= (SELECT revision FROM mtl_item_revisions_b WHERE
4094: revision_id = excl.from_revision_id) AND
4095: ( excl.to_revision_id IS NULL OR
4096: Get_Component_Revision(nvl(be.component_sequence_id,0)) <= (SELECT revision FROM mtl_item_revisions_b WHERE
4097: revision_id = excl.to_revision_id));
4098: error_code := out_code;
4099: err_msg := out_message;
4100:

Line 4539: SELECT revision, revision_id,revision_label FROM mtl_item_revisions_b WHERE

4535: FUNCTION Get_Current_RevisionId( p_inventory_item_id IN NUMBER,
4536: p_organization_id IN NUMBER,
4537: p_effectivity_date IN DATE) RETURN NUMBER IS
4538: CURSOR c1 IS
4539: SELECT revision, revision_id,revision_label FROM mtl_item_revisions_b WHERE
4540: inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id AND
4541: effectivity_date <= p_effectivity_date
4542: AND ((BOM_GLOBALS.get_show_Impl_comps_only = 'Y' AND implementation_date IS NOT NULL) OR BOM_GLOBALS.get_show_Impl_comps_only = 'N') -- added for Bug 7242865
4543: ORDER BY effectivity_date DESC;