DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 438: MTL_SYSTEM_ITEMS_B MSI

434: mti.kanban_card_id,
435: mti.transaction_mode --J-dev
436: FROM MTL_TRANSACTIONS_INTERFACE MTI,
437: MTL_TRANSACTION_LOTS_INTERFACE MTLI,
438: MTL_SYSTEM_ITEMS_B MSI
439: WHERE mti.transaction_interface_id = p_interface_id
440: AND MTI.transaction_interface_id = mtli.transaction_interface_id
441: AND MTI.organization_id = msi.organization_id
442: AND mti.inventory_item_id = msi.inventory_item_id

Line 1860: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;

1856: l_revision VARCHAR(3);
1857: l_subinventory_code VARCHAR(10);
1858: l_locator_id NUMBER;
1859: l_rowid VARCHAR(31);
1860: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1861: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;
1862:
1863: l_qty_check BOOLEAN;
1864: l_lot_control_code number;

Line 1861: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;

1857: l_subinventory_code VARCHAR(10);
1858: l_locator_id NUMBER;
1859: l_rowid VARCHAR(31);
1860: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1861: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;
1862:
1863: l_qty_check BOOLEAN;
1864: l_lot_control_code number;
1865: