APPS.ENG_CHANGE_IMPORT_UTIL dependencies on MTL_ITEM_REVISIONS

Line 3988: FROM MTL_ITEM_REVISIONS_B

3984: , p_rev IN VARCHAR2
3985: )
3986: IS
3987: SELECT REVISION_ID
3988: FROM MTL_ITEM_REVISIONS_B
3989: WHERE INVENTORY_ITEM_ID = p_item_id
3990: AND ORGANIZATION_ID = p_org_id
3991: AND REVISION = p_rev ;
3992:

Line 4055: FROM MTL_ITEM_REVISIONS_B rev_b

4051: , c_org_id IN NUMBER
4052: )
4053: IS
4054: SELECT rev_b.REVISION_ID
4055: FROM MTL_ITEM_REVISIONS_B rev_b
4056: WHERE rev_b.INVENTORY_ITEM_ID = c_item_id
4057: AND rev_b.ORGANIZATION_ID = c_org_id
4058: AND rev_b.REVISION = ( SELECT max(max_rev.revision)
4059: FROM MTL_ITEM_REVISIONS_B max_rev

Line 4059: FROM MTL_ITEM_REVISIONS_B max_rev

4055: FROM MTL_ITEM_REVISIONS_B rev_b
4056: WHERE rev_b.INVENTORY_ITEM_ID = c_item_id
4057: AND rev_b.ORGANIZATION_ID = c_org_id
4058: AND rev_b.REVISION = ( SELECT max(max_rev.revision)
4059: FROM MTL_ITEM_REVISIONS_B max_rev
4060: WHERE max_rev.INVENTORY_ITEM_ID = rev_b.INVENTORY_ITEM_ID
4061: AND max_rev.ORGANIZATION_ID = rev_b.ORGANIZATION_ID
4062: ) ;
4063:

Line 5010: FROM mtl_item_revisions

5006: decode(parent_revision_id,
5007: null,
5008: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
5009: (SELECT effectivity_date + 1/(24*3600)
5010: FROM mtl_item_revisions
5011: WHERE revision_id = parent_revision_id )),
5012: new_effectivity_date) = p_effectivity_date)
5013: OR (decode (new_effectivity_date,
5014: null,

Line 5019: FROM mtl_item_revisions

5015: decode(parent_revision_id,
5016: null,
5017: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
5018: (SELECT effectivity_date + 1/(24*3600)
5019: FROM mtl_item_revisions
5020: WHERE revision_id = parent_revision_id )),
5021: new_effectivity_date) <= p_current_date AND
5022: p_current_date = p_effectivity_date))
5023: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))

Line 5062: FROM mtl_item_revisions

5058: decode(parent_revision_id,
5059: null,
5060: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
5061: (SELECT effectivity_date + 1/(24*3600)
5062: FROM mtl_item_revisions
5063: WHERE revision_id = parent_revision_id )),
5064: new_effectivity_date) = p_effectivity_date)
5065: OR (decode (new_effectivity_date,
5066: null,

Line 5071: FROM mtl_item_revisions

5067: decode(parent_revision_id,
5068: null,
5069: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
5070: (SELECT effectivity_date + 1/(24*3600)
5071: FROM mtl_item_revisions
5072: WHERE revision_id = parent_revision_id )),
5073: new_effectivity_date) <= p_current_date AND
5074: p_current_date = p_effectivity_date))
5075: AND change_id = p_change_id

Line 5120: FROM mtl_item_revisions

5116: decode(parent_revision_id,
5117: null,
5118: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
5119: (SELECT effectivity_date + 1/(24*3600)
5120: FROM mtl_item_revisions
5121: WHERE revision_id = parent_revision_id )),
5122: new_effectivity_date) = p_effectivity_date)
5123: OR (decode (new_effectivity_date,
5124: null,

Line 5129: FROM mtl_item_revisions

5125: decode(parent_revision_id,
5126: null,
5127: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
5128: (SELECT effectivity_date + 1/(24*3600)
5129: FROM mtl_item_revisions
5130: WHERE revision_id = parent_revision_id )),
5131: new_effectivity_date) <= p_current_date AND
5132: p_current_date = p_effectivity_date))
5133: AND change_id = p_change_id