APPS.CSTPWPVR dependencies on WIP_COST_TXN_INTERFACE

Line 24: , WIP_COST_TXN_INTERFACE i

20: /* Commented for bug 12402436
21: cursor c1 is
22: SELECT a2.ROWID the_rowid
23: FROM WIP_TRANSACTION_ACCOUNTS a2
24: , WIP_COST_TXN_INTERFACE i
25: WHERE i.group_id = l_group_id
26: AND i.transaction_id = a2.transaction_id
27: AND a2.base_transaction_value = 0;*/
28: l_msg_count NUMBER := 0;

Line 60: INSERT INTO wip_cost_txn_interface

56: * Insert header rows for each expense non-std job/eam job that is NOT
57: * closed.
58: ****************************************************************/
59: where_num := 100;
60: INSERT INTO wip_cost_txn_interface
61: (TRANSACTION_ID, LAST_UPDATE_DATE,
62: LAST_UPDATED_BY, CREATION_DATE,
63: CREATED_BY, LAST_UPDATE_LOGIN,
64: PROCESS_PHASE, PROCESS_STATUS,

Line 216: wip_cost_txn_interface wcti,

212: wpb.wip_entity_id,
213: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
214: 0, max(cce.cost_element_id), NULL)
215: from
216: wip_cost_txn_interface wcti,
217: wip_discrete_jobs wdj,
218: wip_period_balances wpb,
219: cst_cost_elements cce
220: WHERE wcti.group_id = l_group_id

Line 301: wip_cost_txn_interface wcti,

297: wpb.wip_entity_id,
298: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
299: 0, max(cce.cost_element_id), NULL)
300: from
301: wip_cost_txn_interface wcti,
302: wip_discrete_jobs wdj,
303: wip_period_balances wpb,
304: cst_cost_elements cce
305: WHERE wcti.group_id = l_group_id

Line 373: FROM WIP_COST_TXN_INTERFACE i

369: AND wpb2.acct_period_id <= wpb.acct_period_id)
370: /* sum across all periods */
371: /* WHERE (wpb.acct_period_id, wpb.wip_entity_id) IN
372: (SELECT i.acct_period_id, i.wip_entity_id
373: FROM WIP_COST_TXN_INTERFACE i
374: WHERE i.group_id = l_group_id
375: AND i.line_id IS NULL);*/
376:
377: UPDATE WIP_PERIOD_BALANCES wpb

Line 411: FROM WIP_COST_TXN_INTERFACE i

407: (NVL(TL_OVERHEAD_IN,0)
408: - NVL(TL_OVERHEAD_OUT,0))
409: WHERE (wpb.acct_period_id, wpb.wip_entity_id) IN
410: (SELECT i.acct_period_id, i.wip_entity_id
411: FROM WIP_COST_TXN_INTERFACE i
412: WHERE i.group_id = l_group_id
413: AND i.line_id IS NULL);
414:
415: END IF; /* end for expense jobs */

Line 421: INSERT INTO wip_cost_txn_interface

417: /****************************************************************
418: * Insert header rows for each schedule
419: ****************************************************************/
420: where_num := 200;
421: INSERT INTO wip_cost_txn_interface
422: (TRANSACTION_ID, LAST_UPDATE_DATE,
423: LAST_UPDATED_BY, CREATION_DATE,
424: CREATED_BY, LAST_UPDATE_LOGIN,
425: PROCESS_PHASE, PROCESS_STATUS,

Line 484: FROM wip_cost_txn_interface i,

480: b.repetitive_schedule_id,
481: b.organization_id,
482: SYSDATE, i_user_id, SYSDATE, i_user_id, i_login_id,
483: 0, 0
484: FROM wip_cost_txn_interface i,
485: wip_period_balances b,
486: wip_repetitive_schedules s,
487: org_acct_periods a
488: WHERE i.group_id = l_group_id

Line 573: wip_cost_txn_interface wcti,

569: wpb.repetitive_schedule_id,
570: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
571: 0, max(cce.cost_element_id), NULL)
572: from
573: wip_cost_txn_interface wcti,
574: wip_txn_allocations alloc,
575: wip_period_balances wpb,
576: cst_cost_elements cce,
577: wip_repetitive_schedules wrs

Line 665: wip_cost_txn_interface wcti,

661: wpb.repetitive_schedule_id,
662: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
663: 0, max(cce.cost_element_id), NULL)
664: from
665: wip_cost_txn_interface wcti,
666: wip_txn_allocations alloc,
667: wip_period_balances wpb,
668: cst_cost_elements cce,
669: wip_repetitive_schedules wrs

Line 748: FROM WIP_COST_TXN_INTERFACE i,

744: AND wpb.organization_id = i_org_id
745: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
746: (SELECT i.wip_entity_id,
747: alloc.repetitive_schedule_id
748: FROM WIP_COST_TXN_INTERFACE i,
749: WIP_TXN_ALLOCATIONS alloc
750: WHERE i.group_id = l_group_id
751: AND i.transaction_id = alloc.transaction_id
752: AND i.line_id IS NOT NULL);*/

Line 791: FROM WIP_COST_TXN_INTERFACE i,

787: AND wpb.organization_id = i_org_id
788: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
789: (SELECT i.wip_entity_id,
790: alloc.repetitive_schedule_id
791: FROM WIP_COST_TXN_INTERFACE i,
792: WIP_TXN_ALLOCATIONS alloc
793: WHERE i.group_id = l_group_id
794: AND i.transaction_id = alloc.transaction_id
795: AND i.line_id IS NOT NULL);

Line 823: FROM WIP_COST_TXN_INTERFACE

819: UPDATE WIP_TRANSACTION_ACCOUNTS
820: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
821: WHERE TRANSACTION_ID IN
822: ( SELECT TRANSACTION_ID
823: FROM WIP_COST_TXN_INTERFACE
824: WHERE GROUP_ID = l_group_id
825: AND ORGANIZATION_ID = i_org_id );
826:
827:

Line 861: FROM WIP_COST_TXN_INTERFACE i,

857: AND wpb.organization_id = i_org_id
858: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
859: (SELECT i.wip_entity_id,
860: alloc.repetitive_schedule_id
861: FROM WIP_COST_TXN_INTERFACE i,
862: WIP_TXN_ALLOCATIONS alloc,
863: WIP_REPETITIVE_SCHEDULES s,
864: ORG_ACCT_PERIODS oap
865: WHERE i.group_id = l_group_id

Line 878: | Copy rows from wip_cost_txn_interface to wip_transactions

874: AND oap.organization_id = i_org_id)
875: ;
876:
877: /*---------------------------------------------------------------+
878: | Copy rows from wip_cost_txn_interface to wip_transactions
879: | and delete from wip_cost_txn_interface
880: +---------------------------------------------------------------*/
881: l_status := CSTPWCPX.CMLCPX(l_group_id,i_org_id,5,i_user_id,i_login_id,-1,-1,-1,err_buf);
882: IF l_status <> 0 THEN

Line 879: | and delete from wip_cost_txn_interface

875: ;
876:
877: /*---------------------------------------------------------------+
878: | Copy rows from wip_cost_txn_interface to wip_transactions
879: | and delete from wip_cost_txn_interface
880: +---------------------------------------------------------------*/
881: l_status := CSTPWCPX.CMLCPX(l_group_id,i_org_id,5,i_user_id,i_login_id,-1,-1,-1,err_buf);
882: IF l_status <> 0 THEN
883: RAISE cmlcpx_status;