[Home] [Help]
31: trunc(mmt.transaction_date) txn_date,
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
52: trunc(mmt.transaction_date) txn_date,
53: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
54: from mtl_transaction_accounts mta,
55: mtl_material_transactions mmt,
56: wip_entities we,
57: wip_repetitive_schedules wrs
58: where mmt.transaction_source_type_id = 5
59: and mmt.organization_id = i_org_id
60: and mmt.transaction_source_id = we.wip_entity_id
73: trunc(mmt.transaction_date) txn_date,
74: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
75: from mtl_transaction_accounts mta,
76: mtl_material_transactions mmt,
77: wip_entities we,
78: wip_flow_schedules wfs
79: where mmt.transaction_source_type_id = 5
80: and mmt.organization_id = i_org_id
81: and mmt.transaction_source_id = we.wip_entity_id
113: sum(nvl(wta.base_transaction_value,0)) wip_txn_val
114: from wip_transactions wt,
115: wip_transaction_accounts wta,
116: wip_repetitive_schedules wrs,
117: wip_entities we
118: where wt.organization_id = i_org_id
119: and wt.transaction_id = wta.transaction_id
120: and wta.accounting_line_type = 7
121: and wt.transaction_date between i_push_start_wip_txn_date
452: - nvl(pl_outside_processing_var,0)
453: - nvl(pl_overhead_var,0)) curr_wip_bal
454: from wip_period_balances wpb,
455: wip_repetitive_schedules wrs,
456: wip_entities we
457: where wpb.wip_entity_id = wrs.wip_entity_id
458: and wpb.wip_entity_id = we.wip_entity_id
459: and wrs.status_type in (3,4,5,6,14,15)
460: -- released, complete, complete no charge, on hold,
480: wdj.bom_revision b_revision,
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
498: wrs.bom_revision b_revision,
499: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
500: from mtl_transaction_accounts mta,
501: mtl_material_transactions mmt,
502: wip_entities we,
503: wip_repetitive_schedules wrs
504: where mmt.transaction_source_type_id = 5
505: and mmt.organization_id = i_org_id
506: and mmt.transaction_source_id = we.wip_entity_id
516: wfs.bom_revision b_revision,
517: sum(nvl(mta.base_transaction_value,0)) wip_txn_val
518: from mtl_transaction_accounts mta,
519: mtl_material_transactions mmt,
520: wip_entities we,
521: wip_flow_schedules wfs
522: where mmt.transaction_source_type_id = 5
523: and mmt.organization_id = i_org_id
524: and mmt.transaction_source_id = we.wip_entity_id
550: sum(nvl(wta.base_transaction_value,0)) wip_txn_val
551: from wip_transactions wt,
552: wip_transaction_accounts wta,
553: wip_repetitive_schedules wrs,
554: wip_entities we
555: where wt.organization_id = i_org_id
556: and wt.transaction_id = wta.transaction_id
557: and wta.accounting_line_type = 7
558: and wt.transaction_date between i_push_start_wip_txn_date