APPS.ENG_CHANGE_IMPORT_UTIL dependencies on MTL_ITEM_REVISIONS

Line 3882: FROM MTL_ITEM_REVISIONS_B

3878: , p_rev IN VARCHAR2
3879: )
3880: IS
3881: SELECT REVISION_ID
3882: FROM MTL_ITEM_REVISIONS_B
3883: WHERE INVENTORY_ITEM_ID = p_item_id
3884: AND ORGANIZATION_ID = p_org_id
3885: AND REVISION = p_rev ;
3886:

Line 3949: FROM MTL_ITEM_REVISIONS_B rev_b

3945: , c_org_id IN NUMBER
3946: )
3947: IS
3948: SELECT rev_b.REVISION_ID
3949: FROM MTL_ITEM_REVISIONS_B rev_b
3950: WHERE rev_b.INVENTORY_ITEM_ID = c_item_id
3951: AND rev_b.ORGANIZATION_ID = c_org_id
3952: AND rev_b.REVISION = ( SELECT max(max_rev.revision)
3953: FROM MTL_ITEM_REVISIONS_B max_rev

Line 3953: FROM MTL_ITEM_REVISIONS_B max_rev

3949: FROM MTL_ITEM_REVISIONS_B rev_b
3950: WHERE rev_b.INVENTORY_ITEM_ID = c_item_id
3951: AND rev_b.ORGANIZATION_ID = c_org_id
3952: AND rev_b.REVISION = ( SELECT max(max_rev.revision)
3953: FROM MTL_ITEM_REVISIONS_B max_rev
3954: WHERE max_rev.INVENTORY_ITEM_ID = rev_b.INVENTORY_ITEM_ID
3955: AND max_rev.ORGANIZATION_ID = rev_b.ORGANIZATION_ID
3956: ) ;
3957:

Line 4904: FROM mtl_item_revisions

4900: decode(parent_revision_id,
4901: null,
4902: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
4903: (SELECT effectivity_date + 1/(24*3600)
4904: FROM mtl_item_revisions
4905: WHERE revision_id = parent_revision_id )),
4906: new_effectivity_date) = p_effectivity_date)
4907: OR (decode (new_effectivity_date,
4908: null,

Line 4913: FROM mtl_item_revisions

4909: decode(parent_revision_id,
4910: null,
4911: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
4912: (SELECT effectivity_date + 1/(24*3600)
4913: FROM mtl_item_revisions
4914: WHERE revision_id = parent_revision_id )),
4915: new_effectivity_date) <= p_current_date AND
4916: p_current_date = p_effectivity_date))
4917: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))

Line 4956: FROM mtl_item_revisions

4952: decode(parent_revision_id,
4953: null,
4954: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
4955: (SELECT effectivity_date + 1/(24*3600)
4956: FROM mtl_item_revisions
4957: WHERE revision_id = parent_revision_id )),
4958: new_effectivity_date) = p_effectivity_date)
4959: OR (decode (new_effectivity_date,
4960: null,

Line 4965: FROM mtl_item_revisions

4961: decode(parent_revision_id,
4962: null,
4963: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
4964: (SELECT effectivity_date + 1/(24*3600)
4965: FROM mtl_item_revisions
4966: WHERE revision_id = parent_revision_id )),
4967: new_effectivity_date) <= p_current_date AND
4968: p_current_date = p_effectivity_date))
4969: AND change_id = p_change_id

Line 5014: FROM mtl_item_revisions

5010: decode(parent_revision_id,
5011: null,
5012: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
5013: (SELECT effectivity_date + 1/(24*3600)
5014: FROM mtl_item_revisions
5015: WHERE revision_id = parent_revision_id )),
5016: new_effectivity_date) = p_effectivity_date)
5017: OR (decode (new_effectivity_date,
5018: null,

Line 5023: FROM mtl_item_revisions

5019: decode(parent_revision_id,
5020: null,
5021: nvl(p_parent_rev_eff_date, nvl(effectivity_date, p_current_date)),
5022: (SELECT effectivity_date + 1/(24*3600)
5023: FROM mtl_item_revisions
5024: WHERE revision_id = parent_revision_id )),
5025: new_effectivity_date) <= p_current_date AND
5026: p_current_date = p_effectivity_date))
5027: AND change_id = p_change_id