DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on WIP_ENTITIES

Line 2809: wip_entities we

2805: DELETE FROM mtl_transaction_lots_temp mtlt
2806: WHERE EXISTS
2807: (SELECT 'x'
2808: FROM mtl_material_transactions_temp mmtt,
2809: wip_entities we
2810: WHERE mmtt.transaction_header_id = p_txnHdrID
2811: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
2812: AND mmtt.transaction_source_id = we.wip_entity_id
2813: AND we.entity_type = wip_constants.lotbased

Line 2828: wip_entities we

2824: DELETE FROM mtl_transaction_lots_temp mtlt
2825: WHERE mtlt.transaction_temp_id =
2826: ( SELECT mmtt.transaction_temp_id
2827: FROM mtl_material_transactions_temp mmtt,
2828: wip_entities we
2829: WHERE mmtt.transaction_header_id = p_txnHdrID
2830: AND 1 = ( SELECT count(*)
2831: FROM mtl_transaction_lots_temp mtlt
2832: WHERE mmtt.transaction_temp_id =

Line 2846: wip_entities we

2842: DELETE FROM mtl_transaction_lots_temp mtlt
2843: WHERE EXISTS
2844: (SELECT 'x'
2845: FROM mtl_material_transactions_temp mmtt,
2846: wip_entities we
2847: WHERE mmtt.transaction_header_id = p_txnHdrID
2848: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
2849: AND mmtt.transaction_source_id = we.wip_entity_id
2850: AND we.entity_type = wip_constants.lotbased