DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3781: FROM mtl_material_transactions_temp

3777: END;
3778:
3779: SELECT COUNT(1)
3780: INTO l_valid
3781: FROM mtl_material_transactions_temp
3782: WHERE organization_id = l_organization_id
3783: AND ( lpn_id = p_lpn_id
3784: OR transfer_lpn_id = p_lpn_id
3785: OR content_lpn_id = p_lpn_id

Line 3794: l_table_name := 'MTL_MATERIAL_TRANSACTIONS_TEMP';

3790: IF l_valid > 0 THEN
3791: IF l_debug = 1 THEN
3792: mdebug('Pending MMTT transactions exists against this LPN : '||p_lpn_id||', cannot reuse');
3793: END IF;
3794: l_table_name := 'MTL_MATERIAL_TRANSACTIONS_TEMP';
3795: RAISE l_transactions_pending;
3796: END IF;
3797:
3798: SELECT COUNT(1)