DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3703: FROM mtl_material_transactions_temp

3699: END;
3700:
3701: SELECT COUNT(1)
3702: INTO l_valid
3703: FROM mtl_material_transactions_temp
3704: WHERE organization_id = l_organization_id
3705: AND ( lpn_id = p_lpn_id
3706: OR transfer_lpn_id = p_lpn_id
3707: OR content_lpn_id = p_lpn_id

Line 3716: l_table_name := 'MTL_MATERIAL_TRANSACTIONS_TEMP';

3712: IF l_valid > 0 THEN
3713: IF l_debug = 1 THEN
3714: mdebug('Pending MMTT transactions exists against this LPN : '||p_lpn_id||', cannot reuse');
3715: END IF;
3716: l_table_name := 'MTL_MATERIAL_TRANSACTIONS_TEMP';
3717: RAISE l_transactions_pending;
3718: END IF;
3719:
3720: SELECT COUNT(1)