APPS.WIP_BFLPROC_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 257: from mtl_material_transactions_temp mmtt

253:
254: cursor c_checkExistingMMTT(x_opSeqNum NUMBER, x_inventoryItemID NUMBER,
255: x_txnActionID NUMBER, x_txnTypeID NUMBER) IS
256: select 1
257: from mtl_material_transactions_temp mmtt
258: where mmtt.transaction_source_id = p_wipEntityID
259: and mmtt.organization_id = p_orgID
260: and mmtt.operation_seq_num = x_opSeqNum
261: and mmtt.inventory_item_id = x_inventoryItemID

Line 2836: UPDATE mtl_material_transactions_temp mmtt

2832:
2833: -- Insert all necessary info that need to be used by inventory form to
2834: -- gather lot/serial from the user
2835: IF(x_bfRequired = WIP_CONSTANTS.WBF_BF_PAGE)THEN
2836: UPDATE mtl_material_transactions_temp mmtt
2837: SET (mmtt.item_segments,
2838: mmtt.item_description,
2839: mmtt.item_trx_enabled_flag,
2840: mmtt.item_location_control_code,

Line 2882: UPDATE mtl_material_transactions_temp mmtt

2878: * routing. We should seperate statement to set mmtt.department_code
2879: * from statement to update other columns.
2880: */
2881: -- set department code if mmtt.department_id is not null
2882: UPDATE mtl_material_transactions_temp mmtt
2883: SET (mmtt.department_code)
2884: =
2885: (SELECT bd.department_code
2886: FROM bom_departments bd

Line 2898: UPDATE mtl_material_transactions_temp mmtt

2894: IF(l_lot_entry_type IN (WIP_CONSTANTS.RECDATE_FULL,
2895: WIP_CONSTANTS.EXPDATE_FULL,
2896: WIP_CONSTANTS.TXNHISTORY_FULL)) THEN
2897:
2898: UPDATE mtl_material_transactions_temp mmtt
2899: SET mmtt.lot_number =
2900: ( SELECT mtlt.lot_number
2901: FROM mtl_transaction_lots_temp mtlt
2902: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 2917: FROM mtl_material_transactions_temp mmtt,

2913: /* Bug 6342487 - FP of Bug 6111292 - Moved this delete statement from below */
2914: DELETE FROM mtl_transaction_lots_temp mtlt
2915: WHERE EXISTS
2916: (SELECT 'x'
2917: FROM mtl_material_transactions_temp mmtt,
2918: wip_entities we
2919: WHERE mmtt.transaction_header_id = p_txnHdrID
2920: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
2921: AND mmtt.transaction_source_id = we.wip_entity_id

Line 2936: FROM mtl_material_transactions_temp mmtt,

2932: /*
2933: DELETE FROM mtl_transaction_lots_temp mtlt
2934: WHERE mtlt.transaction_temp_id =
2935: ( SELECT mmtt.transaction_temp_id
2936: FROM mtl_material_transactions_temp mmtt,
2937: wip_entities we
2938: WHERE mmtt.transaction_header_id = p_txnHdrID
2939: AND 1 = ( SELECT count(*)
2940: FROM mtl_transaction_lots_temp mtlt

Line 2954: FROM mtl_material_transactions_temp mmtt,

2950: there is no need to delete since the component rows will not be visible in the UI.
2951: DELETE FROM mtl_transaction_lots_temp mtlt
2952: WHERE EXISTS
2953: (SELECT 'x'
2954: FROM mtl_material_transactions_temp mmtt,
2955: wip_entities we
2956: WHERE mmtt.transaction_header_id = p_txnHdrID
2957: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
2958: AND mmtt.transaction_source_id = we.wip_entity_id

Line 2973: UPDATE mtl_material_transactions_temp mmtt

2969: -- we can derive. If it is not equal to required quantity, user need to provide
2970: -- more lot/serial information.
2971: /*
2972: -- Only update transaction_quantity for item under lot/serial.
2973: UPDATE mtl_material_transactions_temp mmtt
2974: SET mmtt.transaction_quantity =
2975: (SELECT NVL(SUM(mtlt.transaction_quantity),0)
2976: FROM mtl_transaction_lots_temp mtlt
2977: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id)