DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1510: FROM csd_repair_job_xref crj,wip_requirement_operations wro

1506: fnd_global.user_id created_by,
1507: sysdate creation_date,
1508: fnd_global.user_id last_updated_by,
1509: sysdate last_update_date
1510: FROM csd_repair_job_xref crj,wip_requirement_operations wro
1511: WHERE crj.wip_entity_id = wro.wip_entity_id
1512: AND crj.repair_line_id = p_repair_line_id
1513: AND NOT EXISTS (SELECT 'exists'
1514: FROM csd_wip_transaction_details cwt

Line 1544: FROM wip_requirement_operations wro

1540: fnd_global.user_id created_by,
1541: sysdate creation_date,
1542: fnd_global.user_id last_updated_by,
1543: sysdate last_update_date
1544: FROM wip_requirement_operations wro
1545: WHERE wro.wip_entity_id = p_wip_entity_id
1546: AND NOT EXISTS (SELECT 'exists'
1547: FROM csd_wip_transaction_details cwt
1548: WHERE cwt.wip_entity_id = wro.wip_entity_id

Line 1574: FROM wip_requirement_operations wro,csd_repair_job_xref crj

1570: fnd_global.user_id created_by,
1571: sysdate creation_date,
1572: fnd_global.user_id last_updated_by,
1573: sysdate last_update_date
1574: FROM wip_requirement_operations wro,csd_repair_job_xref crj
1575: WHERE crj.wip_entity_id = wro.wip_entity_id
1576: AND NOT EXISTS (SELECT 'exists'
1577: FROM csd_wip_transaction_details cwt
1578: WHERE cwt.wip_entity_id = wro.wip_entity_id

Line 4750: from wip_requirement_operations

4746: p_operation_seq_num NUMBER,
4747: p_wip_entity_id NUMBER,
4748: p_organization_id NUMBER) IS
4749: SELECT nvl(quantity_issued, 0)
4750: from wip_requirement_operations
4751: where inventory_item_id = p_inventory_item_id
4752: and operation_seq_num = p_operation_seq_num
4753: and wip_entity_id = p_wip_entity_id
4754: and organization_id = p_organization_id;

Line 6363: from wip_requirement_operations_v

6359: --bug#13472453
6360:
6361: CURSOR c_count_material(p_wip_entity_id NUMBER, l_inventory_item_id NUMBER) IS
6362: select 'X'
6363: from wip_requirement_operations_v
6364: where wip_entity_id = p_wip_entity_id
6365: and inventory_item_id = l_inventory_item_id
6366: and rownum = 1;
6367:

Line 7113: from wip_requirement_operations_v

7109: operation_seq_num,
7110: required_quantity,
7111: item_primary_uom_code,
7112: supply_subinventory
7113: from wip_requirement_operations_v
7114: where wip_entity_id = p_wip_entity_id;
7115:
7116:
7117: -- Counter used for populating l_x_job_bill_routing_tbl table with

Line 7173: from wip_requirement_operations_v

7169: --bug#13472453
7170:
7171: CURSOR c_count_material(p_wip_entity_id NUMBER, l_inventory_item_id NUMBER) IS
7172: select 'X'
7173: from wip_requirement_operations_v
7174: where wip_entity_id = p_wip_entity_id
7175: and inventory_item_id = l_inventory_item_id
7176: and rownum = 1;
7177:

Line 8058: WIP_REQUIREMENT_OPERATIONS WRO,

8054: , CWTD.attribute15
8055: , CWTD.create_ro_flag --bug#13698799 auto create ro, parent ro
8056: FROM
8057: CSD_REPAIR_JOB_XREF CRJX,
8058: WIP_REQUIREMENT_OPERATIONS WRO,
8059: MTL_SYSTEM_ITEMS_KFV MSIK,
8060: WIP_ENTITIES WE,
8061: CSD_WIP_TRANSACTION_DETAILS CWTD,
8062: WIP_DISCRETE_JOBS WDJ,

Line 9448: from WIP_REQUIREMENT_OPERATIONS wip

9444: and rownum = 1;
9445:
9446: cursor c_mat_txn_exists is
9447: select 'exists'
9448: from WIP_REQUIREMENT_OPERATIONS wip
9449: where wip.wip_entity_id = p_wip_entity_id
9450: and wip.operation_seq_num = p_operation_seq_num
9451: and wip.quantity_issued > 0
9452: and rownum = 1;

Line 9604: from WIP_REQUIREMENT_OPERATIONS wip,

9600: select csd.wip_transaction_detail_id,
9601: csd.object_version_number,
9602: wip.required_quantity,
9603: nvl(wip.quantity_issued, 0)
9604: from WIP_REQUIREMENT_OPERATIONS wip,
9605: CSD_WIP_TRANSACTION_DETAILS csd
9606: where wip.wip_entity_id = p_op_dtls.wip_entity_id
9607: and wip.operation_seq_num = p_operation_seq_num
9608: and wip.inventory_item_id = p_inventory_item_id

Line 9944: FROM mtl_material_transactions mmt,wip_requirement_operations wro

9940: THEN
9941: UPDATE csd_wip_transaction_details cwt SET cwt.quantity_issued = (NVL(cwt.quantity_issued,0) + p_quantity)
9942: WHERE cwt.wip_transaction_detail_id = p_wip_transaction_detail_id
9943: AND EXISTS (SELECT SUM(transaction_quantity)
9944: FROM mtl_material_transactions mmt,wip_requirement_operations wro
9945: WHERE mmt.inventory_item_id = cwt.inventory_item_id
9946: AND wro.wip_entity_id = cwt.wip_entity_id
9947: AND wro.inventory_item_id = cwt.inventory_item_id
9948: AND wro.organization_id = mmt.organization_id

Line 9961: FROM mtl_material_transactions mmt,wip_requirement_operations wro

9957: THEN
9958: UPDATE csd_wip_transaction_details cwt SET cwt.quantity_recovered = (NVL(cwt.quantity_recovered,0) + p_quantity)
9959: WHERE wip_transaction_detail_id = p_wip_transaction_detail_id
9960: AND EXISTS (SELECT SUM(transaction_quantity)
9961: FROM mtl_material_transactions mmt,wip_requirement_operations wro
9962: WHERE mmt.inventory_item_id = cwt.inventory_item_id
9963: AND wro.wip_entity_id = cwt.wip_entity_id
9964: AND wro.inventory_item_id = cwt.inventory_item_id
9965: AND wro.organization_id = mmt.organization_id

Line 9983: -- first we will synch up csd_wip_transaction_details with wip_requirement_operations.

9979: NULL;
9980:
9981: -- case#3. WIP entity id is provided.
9982: -- the second best case now!
9983: -- first we will synch up csd_wip_transaction_details with wip_requirement_operations.
9984: ELSIF p_wip_entity_id IS NOT NULL
9985: THEN
9986: handle_missing_mat_rqmts(p_wip_entity_id => p_wip_entity_id);
9987:

Line 9990: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

9986: handle_missing_mat_rqmts(p_wip_entity_id => p_wip_entity_id);
9987:
9988: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
9989: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
9990: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
9991: csd_wip_transaction_details cwt
9992: WHERE cwt.wip_entity_id = p_wip_entity_id
9993: AND cwt.wip_entity_id = wro.wip_entity_id
9994: AND cwt.inventory_item_id = wro.inventory_item_id

Line 10027: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10023: handle_missing_mat_rqmts(p_repair_line_id => p_repair_line_id);
10024:
10025: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10026: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
10027: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10028: csd_wip_transaction_details cwt,csd_repair_job_xref crj
10029: WHERE crj.repair_line_id = p_repair_line_id
10030: AND cwt.wip_entity_id = crj.wip_entity_id
10031: AND cwt.wip_entity_id = wro.wip_entity_id

Line 10060: from mtl_material_transactions mmt, wip_requirement_operations wro,

10056: handle_missing_mat_rqmts(p_repair_line_id => p_repair_line_id);
10057:
10058: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10059: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
10060: from mtl_material_transactions mmt, wip_requirement_operations wro,
10061: csd_wip_transaction_details cwt,csd_repair_job_xref crj,wip_discrete_jobs wdj
10062: WHERE crj.repair_line_id = p_repair_line_id
10063: AND cwt.wip_entity_id = crj.wip_entity_id
10064: AND cwt.wip_entity_id = wro.wip_entity_id

Line 10102: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10098: IF p_exclude_closed_jobs = 'N'
10099: THEN
10100: OPEN l_all_jobs FOR
10101: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10102: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10103: csd_wip_transaction_details cwt
10104: WHERE cwt.wip_entity_id = wro.wip_entity_id
10105: AND cwt.inventory_item_id = wro.inventory_item_id
10106: AND cwt.operation_seq_num = wro.operation_seq_num

Line 10133: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10129: CLOSE l_all_jobs;
10130: ELSE
10131: OPEN l_all_jobs FOR
10132: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10133: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10134: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10135: WHERE cwt.wip_entity_id = wro.wip_entity_id
10136: AND cwt.inventory_item_id = wro.inventory_item_id
10137: AND cwt.operation_seq_num = wro.operation_seq_num

Line 10170: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10166: IF p_exclude_closed_jobs = 'N'
10167: THEN
10168: OPEN l_all_jobs FOR
10169: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10170: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10171: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10172: WHERE cwt.wip_entity_id = wro.wip_entity_id
10173: AND cwt.inventory_item_id = wro.inventory_item_id
10174: AND cwt.operation_seq_num = wro.operation_seq_num

Line 10204: FROM mtl_material_transactions mmt, wip_requirement_operations wro,

10200:
10201: ELSE
10202: OPEN l_all_jobs FOR
10203: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10204: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10205: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10206: WHERE cwt.wip_entity_id = wro.wip_entity_id
10207: AND cwt.inventory_item_id = wro.inventory_item_id
10208: AND cwt.operation_seq_num = wro.operation_seq_num