APPS.BOMPINRV dependencies on MTL_ITEM_REVISIONS_B

Line 14: from mtl_item_revisions_b a

10:
11: Cursor get_current_rev is
12: select a.revision,
13: nvl(length(rtrim(a.revision,'0123456789')),0) rev_len
14: from mtl_item_revisions_b a
15: where a.organization_id = i_org_id
16: and a.inventory_item_id = i_item_id
17: and a.effectivity_date = (
18: select max(b.effectivity_date)

Line 19: from mtl_item_revisions_b b

15: where a.organization_id = i_org_id
16: and a.inventory_item_id = i_item_id
17: and a.effectivity_date = (
18: select max(b.effectivity_date)
19: from mtl_item_revisions_b b
20: where b.inventory_item_id = a.inventory_item_id
21: and b.organization_id = a.organization_id
22: and b.effectivity_date <= i_date_time)
23: -- and b.implementation_date is not null)

Line 29: from mtl_item_revisions_b r

25: order by a.revision desc; --* Added for Bug #3483066
26: current_rev get_current_rev%rowtype;
27: Cursor check_duplicate_rev(rev in varchar) is
28: select 'x'
29: from mtl_item_revisions_b r
30: where r.organization_id = i_org_id
31: and r.inventory_item_id = i_item_id
32: and r.revision = rev;
33: dummy varchar2(1);

Line 70: Insert into mtl_item_revisions_b(

66: Fetch check_duplicate_rev into dummy;
67: If check_duplicate_rev%found then
68: o_out_code := null;
69: else
70: Insert into mtl_item_revisions_b(
71: inventory_item_id,
72: organization_id,
73: revision,
74: last_update_date,

Line 101: MTL_ITEM_REVISIONS_B_S.nextval,

97: who.appid,
98: who.progid,
99: sysdate,
100: who.reqstid,
101: MTL_ITEM_REVISIONS_B_S.nextval,
102: new_item_revision,
103: 1) RETURNING revision_id INTO i_revision_id;
104:
105: SELECT userenv('LANG') INTO i_language_code FROM dual;