DBA Data[Home] [Help]

APPS.OPIMPXWP dependencies on WIP_TRANSACTIONS

Line 96: from wip_transactions wt,

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

Line 114: from wip_transactions wt,

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

Line 134: from wip_transactions wt,

130: select wfs.primary_item_id item_id, -- resource charges for flow schedules
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

Line 209: - update beginning balances with daily WIP transactions within

205: If so, we need to do the following:
206: - delete existing WIP opi_ids_push_log rows within the process
207: date ranges to avoid duplication in case of repush
208: - calculate the beginning balance at the start date
209: - update beginning balances with daily WIP transactions within
210: the process date ranges.
211: If it is not a first push and WIP rows exist within the date
212: range, it is a repush. We need to set the push_flag to null
213: to indicate that these rows are repushed.

Line 536: from wip_transactions wt,

532: UNION ALL
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

Line 551: from wip_transactions wt,

547: UNION ALL
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

Line 568: from wip_transactions wt,

564: UNION ALL
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