DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on MTL_ITEM_REVISIONS

Line 3163: from mtl_item_revisions mir

3159: l_sql_stmt_no := 50;
3160:
3161: select MAX(revision)
3162: into l_revision
3163: from mtl_item_revisions mir
3164: where inventory_item_id = l_kanban_card_Rec_Tbl(1).Inventory_Item_Id
3165: and organization_id = l_kanban_card_Rec_Tbl(1).organization_Id
3166: and effectivity_date < SYSDATE
3167: and implementation_date is not null /* Added for bug 7110794 */

Line 3171: from mtl_item_revisions mir1

3167: and implementation_date is not null /* Added for bug 7110794 */
3168: and effectivity_date =
3169: (
3170: select MAX(effectivity_date)
3171: from mtl_item_revisions mir1
3172: where mir1.inventory_item_id = mir.inventory_item_id
3173: and mir1.organization_id = mir.organization_id
3174: and implementation_date is not null /* Added for bug 7110794 */
3175: and effectivity_date < SYSDATE