DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on MTL_ITEM_REVISIONS

Line 2165: -- check if valid revision in mtl_item_revisions.

2161:
2162: ELSIF crec.revision IS NOT NULL THEN
2163:
2164: -- ELSIF TRANSLATE Txn and ITemRevision is NOT NULL Then
2165: -- check if valid revision in mtl_item_revisions.
2166:
2167: BEGIN
2168: SELECT 1
2169: into x_dummy

Line 2170: FROM mtl_item_revisions

2166:
2167: BEGIN
2168: SELECT 1
2169: into x_dummy
2170: FROM mtl_item_revisions
2171: WHERE inventory_item_id = crec.inventory_item_id
2172: and organization_id = crec.organization_id
2173: and revision = crec.revision;
2174: EXCEPTION when others THEN