[Home] [Help]
92: -1,
93: SYSDATE,
94: SYSDATE
95: FROM
96: WIP_TRANSACTION_ACCOUNTS WTA,
97: WIP_COST_TXN_INTERFACE WCTI,
98: WIP_ENTITIES WE
99: WHERE
100: WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
148: nvl(sum(wta.primary_quantity),0),
149: nvl(w1.applied_ovhd_value,0) +
150: nvl(sum(wta.base_transaction_value),0)
151: FROM
152: WIP_TRANSACTION_ACCOUNTS WTA,
153: WIP_COST_TXN_INTERFACE WCTI
154: WHERE
155: W1.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID AND
156: W1.OPERATION_SEQ_NUM = WCTI.OPERATION_SEQ_NUM AND
186: WCTI2.WIP_ENTITY_ID,WCTI2.ORGANIZATION_ID,WCTI2.OPERATION_SEQ_NUM,
187: WCTI2.RESOURCE_SEQ_NUM, WTA2.RESOURCE_ID, WTA2.BASIS_TYPE
188: FROM
189: WIP_COST_TXN_INTERFACE WCTI2,
190: WIP_TRANSACTION_ACCOUNTS WTA2
191: WHERE
192: /* Added for bug 3646550 */
193: WTA2.TRANSACTION_ID = WCTI2.TRANSACTION_ID AND
194: WTA2.WIP_ENTITY_ID = WCTI2.WIP_ENTITY_ID AND
259: -1,
260: SYSDATE,
261: SYSDATE
262: FROM
263: WIP_TRANSACTION_ACCOUNTS WTA,
264: WIP_COST_TXN_INTERFACE WCTI,
265: WIP_ENTITIES WE
266: WHERE
267: WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
305: NVL(w1.applied_ovhd_units,0) + NVL(SUM(wta.primary_quantity),0),
306: NVL(w1.applied_ovhd_value,0) + NVL(SUM(wta.base_transaction_value),0)
307: FROM
308: wip_cost_txn_interface wcti,
309: wip_transaction_accounts wta,
310: wip_operations wo
311: WHERE
312: w1.wip_entity_id = wcti.wip_entity_id AND
313: w1.organization_id = wcti.organization_id and
351: wta2.resource_id
352: FROM
353: wip_operations wo2,
354: wip_cost_txn_interface wcti2,
355: wip_transaction_accounts wta2
356: WHERE
357: wta2.wip_entity_id = wcti2.wip_entity_id and
358: wta2.transaction_id = wcti2.transaction_id and
359: wta2.basis_type in (1,2) and