oracle工单结算,有关于工单成本结帐的问题

以下是TAR给的答复，供大家参考：

For the problematic job please provide the following information:

Kindly provide the output of the following queries in a neat excel sheet. Kindly use worksheets in the same Excel sheet instead of different

excel sheets.

1. select wip_entity_id from wip_entities where wip_entity_name = '&jobname';

This would provide you the wip_entity_id used in the following queries

2. select * from wip_discrete_jobs where wip_entity_id = ;

3. select * from wip_operations where wip_entity_id = ;

4. select * from wip_requirement_operations where wip_entity_id =

y_id>;

5. select * from wip_move_transactions where wip_entity_id = ;

6. select * from wip_period_balances where wip_entity_id = ;

7. select * from wip_transaction_accounts where wip_entity_id = ;

8. select * from wip_transactions where wip_entity_id = ;

9. select * from mtl_material_transactions where transaction_source_id =

wip_entity_id> and transaction_source_type_id = 5;

10. select * from mtl_material_transactions_temp where transaction_source_id =

wip_entity_id> and transaction_source_type_id = 5;

11. select * from mtl_transaction_accounts where transaction_source_id =

wip_entity_id> ;

B) Please provide the output of "Discrete Job Value report - Details" for the current WIP Job.