APPS.CSTACWRO dependencies on WIP_COST_TXN_INTERFACE

Line 97: WIP_COST_TXN_INTERFACE WCTI,

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
101: WE.ENTITY_TYPE <> 4 AND

Line 153: WIP_COST_TXN_INTERFACE WCTI

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
157: W1.ORGANIZATION_ID = WCTI.ORGANIZATION_ID AND

Line 189: WIP_COST_TXN_INTERFACE WCTI2,

185: (SELECT
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

Line 264: WIP_COST_TXN_INTERFACE WCTI,

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
268: WE.ENTITY_TYPE <> 4 AND

Line 308: wip_cost_txn_interface wcti,

304: (SELECT
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

Line 354: wip_cost_txn_interface wcti2,

350: wta2.basis_type,
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