[Home] [Help]
32: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
33: from mtl_transaction_accounts mta,
34: mtl_material_transactions mmt,
35: wip_entities we,
36: wip_discrete_jobs wdj
37: where mmt.transaction_source_type_id = 5
38: and mmt.organization_id = i_org_id
39: and mmt.transaction_source_id = we.wip_entity_id
40: and mmt.transaction_id = mta.transaction_id
94: trunc(wt.transaction_date) txn_date,
95: sum(nvl(wta.base_transaction_value,0)) wip_txn_val
96: from wip_transactions wt,
97: wip_transaction_accounts wta,
98: wip_discrete_jobs wdj
99: where wt.organization_id = i_org_id
100: and wt.transaction_id = wta.transaction_id
101: and wta.accounting_line_type = 7
102: and wt.transaction_date between i_push_start_wip_txn_date
420: - nvl(pl_resource_var,0)
421: - nvl(pl_outside_processing_var,0)
422: - nvl(pl_overhead_var,0)) curr_wip_bal
423: from wip_period_balances wpb,
424: wip_discrete_jobs wdj
425: where wpb.wip_entity_id = wdj.wip_entity_id
426: and wdj.status_type in (3,4,5,6,14,15)
427: -- released, complete, complete no charge, on hold,
428: -- pending close, failed close respectively.
481: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
482: from mtl_transaction_accounts mta,
483: mtl_material_transactions mmt,
484: wip_entities we,
485: wip_discrete_jobs wdj
486: where mmt.transaction_source_type_id = 5
487: and mmt.organization_id = i_org_id
488: and mmt.transaction_source_id = we.wip_entity_id
489: and mmt.transaction_id = mta.transaction_id
534: wdj.bom_revision b_revision,
535: sum(nvl(wta.base_transaction_value,0)) wip_txn_val
536: from wip_transactions wt,
537: wip_transaction_accounts wta,
538: wip_discrete_jobs wdj
539: where wt.organization_id = i_org_id
540: and wt.transaction_id = wta.transaction_id
541: and wta.accounting_line_type = 7
542: and wt.transaction_date between i_push_start_wip_txn_date