[Home] [Help]
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
61: and mmt.transaction_id = mta.transaction_id
112: trunc(wt.transaction_date) txn_date,
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
451: - nvl(pl_resource_var,0)
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)
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
507: and mmt.transaction_id = mta.transaction_id
549: wrs.bom_revision b_revision,
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