DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on WIP_REQUIREMENT_OPERATIONS

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 3056: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

3052:
3053: CURSOR c_all_mtl_transactions(p_repair_line_id NUMBER)
3054: IS
3055: SELECT mmt.reason_id,mmt.inventory_item_id,wdj.primary_item_id,wro.organization_id
3056: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
3057: csd_repair_job_xref crj, wip_discrete_jobs wdj
3058: WHERE crj.repair_line_id = p_repair_line_id
3059: AND crj.wip_entity_id = wro.wip_entity_id
3060: AND wro.operation_seq_num = mmt.operation_seq_num