APPS.CSD_REPAIRS_UTIL dependencies on CSD_WIP_TRANSACTION_DETAILS

Line 2662: FROM csd_wip_transaction_details

2658: l_mtl_txn_dtls_upd(k).new_row := 'N';
2659: l_mtl_txn_dtls_upd(k).transaction_quantity := 0;
2660: SELECT wip_transaction_detail_id
2661: INTO l_mtl_txn_dtls_upd(k).wip_transaction_detail_id
2662: FROM csd_wip_transaction_details
2663: WHERE wip_entity_id = p_wip_entity_id_tbl(k)
2664: AND inventory_item_id = p_item_id_tbl(k)
2665: AND operation_seq_num = p_op_seq_num_tbl(k);
2666:

Line 2677: FROM csd_wip_transaction_details cwt,wip_requirement_operations wro

2673: BEGIN
2674: SELECT 'N',wip_transaction_detail_id,NVL(cwt.transaction_quantity,
2675: wro.required_quantity-wro.quantity_issued)+l_quantity_tbl(k)
2676: INTO l_mtl_txn_dtls_tab(k).new_row,l_mtl_txn_dtls_tab(k).wip_transaction_detail_id,l_mtl_txn_dtls_tab(k).required_quantity
2677: FROM csd_wip_transaction_details cwt,wip_requirement_operations wro
2678: WHERE cwt.wip_entity_id = l_wip_entity_id_tbl(k)
2679: AND cwt.inventory_item_id = l_item_id_tbl(k)
2680: AND cwt.operation_seq_num = l_op_seq_num_tbl(k)
2681: AND cwt.wip_entity_id = wro.wip_entity_id

Line 2744: UPDATE csd_wip_transaction_details cwt SET substitutes = l_mtl_txn_dtls_upd(k).inventory_item_id

2740: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Bulk updating all the substitute material requirement lines.');
2741: END IF;
2742: FOR k IN 1 ..l_mtl_txn_dtls_tab.COUNT
2743: LOOP
2744: UPDATE csd_wip_transaction_details cwt SET substitutes = l_mtl_txn_dtls_upd(k).inventory_item_id
2745: WHERE cwt.wip_entity_id = l_mtl_txn_dtls_tab(k).wip_entity_id
2746: AND cwt.operation_seq_num = l_mtl_txn_dtls_tab(k).operation_seq_num
2747: AND cwt.inventory_item_id = l_mtl_txn_dtls_tab(k).inventory_item_id;
2748:

Line 2749: UPDATE csd_wip_transaction_details SET is_substituted = 'Y'

2745: WHERE cwt.wip_entity_id = l_mtl_txn_dtls_tab(k).wip_entity_id
2746: AND cwt.operation_seq_num = l_mtl_txn_dtls_tab(k).operation_seq_num
2747: AND cwt.inventory_item_id = l_mtl_txn_dtls_tab(k).inventory_item_id;
2748:
2749: UPDATE csd_wip_transaction_details SET is_substituted = 'Y'
2750: WHERE wip_entity_id = l_mtl_txn_dtls_upd(k).wip_entity_id
2751: AND operation_seq_num = l_mtl_txn_dtls_upd(k).operation_seq_num
2752: AND inventory_item_id = l_mtl_txn_dtls_upd(k).inventory_item_id;
2753:

Line 2898: csd_repair_job_xref crj,csd_wip_transaction_details cwt

2894: -- SELECT all the requisition id's originated from CSD and are not yet interfaced to OM.
2895: SELECT prh.requisition_header_id
2896: BULK COLLECT INTO l_requisition_id
2897: FROM po_requisition_headers_all prh,po_requisition_lines_all prl,
2898: csd_repair_job_xref crj,csd_wip_transaction_details cwt
2899: WHERE crj.wip_entity_id = cwt.wip_entity_id
2900: AND cwt.wip_entity_id = prl.wip_entity_id
2901: AND cwt.inventory_item_id = prl.item_id
2902: AND cwt.operation_seq_num = prl.wip_operation_seq_num