DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 3277: FROM mtl_transaction_lots_temp mtlt

3273: AND NVL(mmtt.content_lpn_id,-99) <> p_lpn_id;
3274: CURSOR mtlt_cur(l_transaction_temp_id NUMBER)
3275: IS
3276: SELECT mtlt.lot_number
3277: FROM mtl_transaction_lots_temp mtlt
3278: where transaction_temp_id = l_transaction_temp_id;
3279: CURSOR msn_cur(l_cur_lpn_id NUMBER , l_cur_inventory_item_id NUMBER)
3280: IS
3281: SELECT msn.status_id

Line 3796: FROM mtl_transaction_lots_temp mtlt

3792:
3793: CURSOR mtlt_cur(l_transaction_temp_id NUMBER)
3794: IS
3795: SELECT mtlt.lot_number
3796: FROM mtl_transaction_lots_temp mtlt
3797: where transaction_temp_id = l_transaction_temp_id;
3798:
3799: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3800: IS