APPS.OPIMPXWP dependencies on WIP_TRANSACTION_ACCOUNTS

Line 97: wip_transaction_accounts wta,

93: wdj.bom_revision b_revision,
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

Line 115: wip_transaction_accounts wta,

111: wrs.bom_revision b_revision,
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

Line 135: wip_transaction_accounts wta,

131: wfs.bom_revision b_revision,
132: trunc(wt.transaction_date) txn_date,
133: sum(nvl(wta.base_transaction_value,0)) wip_txn_val
134: from wip_transactions wt,
135: wip_transaction_accounts wta,
136: wip_flow_schedules wfs
137: where wt.organization_id = i_org_id
138: and wt.transaction_id = wta.transaction_id
139: and wta.accounting_line_type = 7

Line 537: wip_transaction_accounts wta,

533: select wdj.primary_item_id item_id, -- resource charges for discrete jobs
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

Line 552: wip_transaction_accounts wta,

548: select we.primary_item_id item_id, -- resource charges for rep. schedules
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

Line 569: wip_transaction_accounts wta,

565: select wfs.primary_item_id item_id, -- resource charges for flow schedules
566: wfs.bom_revision b_revision,
567: sum(nvl(wta.base_transaction_value,0)) wip_txn_val
568: from wip_transactions wt,
569: wip_transaction_accounts wta,
570: wip_flow_schedules wfs
571: where wt.organization_id = i_org_id
572: and wt.transaction_id = wta.transaction_id
573: and wta.accounting_line_type = 7