eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSTPWPVR dependencies on WIP_COST_TXN_INTERFACE

Line 23: , WIP_COST_TXN_INTERFACE i

19: my_rowid ROWID;
20: cursor c1 is
21: SELECT a2.ROWID the_rowid
22: FROM WIP_TRANSACTION_ACCOUNTS a2
23: , WIP_COST_TXN_INTERFACE i
24: WHERE i.group_id = l_group_id
25: AND i.transaction_id = a2.transaction_id
26: AND a2.base_transaction_value = 0;
27: l_msg_count NUMBER := 0;

Line 59: INSERT INTO wip_cost_txn_interface

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

Line 186: wip_cost_txn_interface wcti,

182: wpb.wip_entity_id,
183: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
184: 0, max(cce.cost_element_id), NULL)
185: from
186: wip_cost_txn_interface wcti,
187: wip_period_balances wpb,
188: cst_cost_elements cce,
189: wip_discrete_jobs wdj
190: WHERE wcti.group_id = l_group_id

Line 271: wip_cost_txn_interface wcti,

267: wpb.wip_entity_id,
268: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
269: 0, max(cce.cost_element_id), NULL)
270: from
271: wip_cost_txn_interface wcti,
272: wip_period_balances wpb,
273: cst_cost_elements cce,
274: wip_discrete_jobs wdj
275: WHERE wcti.group_id = l_group_id

Line 342: FROM WIP_COST_TXN_INTERFACE i

338: AND wpb2.acct_period_id <= wpb.acct_period_id)
339: /* sum across all periods */
340: WHERE (wpb.acct_period_id, wpb.wip_entity_id) IN
341: (SELECT i.acct_period_id, i.wip_entity_id
342: FROM WIP_COST_TXN_INTERFACE i
343: WHERE i.group_id = l_group_id
344: AND i.line_id IS NULL);
345:
346: END IF; /* end for expense jobs */

Line 352: INSERT INTO wip_cost_txn_interface

348: /****************************************************************
349: * Insert header rows for each schedule
350: ****************************************************************/
351: where_num := 200;
352: INSERT INTO wip_cost_txn_interface
353: (TRANSACTION_ID, LAST_UPDATE_DATE,
354: LAST_UPDATED_BY, CREATION_DATE,
355: CREATED_BY, LAST_UPDATE_LOGIN,
356: PROCESS_PHASE, PROCESS_STATUS,

Line 415: FROM wip_cost_txn_interface i,

411: b.repetitive_schedule_id,
412: b.organization_id,
413: SYSDATE, i_user_id, SYSDATE, i_user_id, i_login_id,
414: 0, 0
415: FROM wip_cost_txn_interface i,
416: wip_period_balances b,
417: wip_repetitive_schedules s,
418: org_acct_periods a
419: WHERE i.group_id = l_group_id

Line 504: wip_cost_txn_interface wcti,

500: wpb.repetitive_schedule_id,
501: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
502: 0, max(cce.cost_element_id), NULL)
503: from
504: wip_cost_txn_interface wcti,
505: wip_txn_allocations alloc,
506: wip_period_balances wpb,
507: cst_cost_elements cce,
508: wip_repetitive_schedules wrs

Line 596: wip_cost_txn_interface wcti,

592: wpb.repetitive_schedule_id,
593: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
594: 0, max(cce.cost_element_id), NULL)
595: from
596: wip_cost_txn_interface wcti,
597: wip_txn_allocations alloc,
598: wip_period_balances wpb,
599: cst_cost_elements cce,
600: wip_repetitive_schedules wrs

Line 678: FROM WIP_COST_TXN_INTERFACE i,

674: AND wpb.organization_id = i_org_id
675: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
676: (SELECT i.wip_entity_id,
677: alloc.repetitive_schedule_id
678: FROM WIP_COST_TXN_INTERFACE i,
679: WIP_TXN_ALLOCATIONS alloc
680: WHERE i.group_id = l_group_id
681: AND i.transaction_id = alloc.transaction_id
682: AND i.line_id IS NOT NULL);

Line 710: FROM WIP_COST_TXN_INTERFACE

706: UPDATE WIP_TRANSACTION_ACCOUNTS
707: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
708: WHERE TRANSACTION_ID IN
709: ( SELECT TRANSACTION_ID
710: FROM WIP_COST_TXN_INTERFACE
711: WHERE GROUP_ID = l_group_id
712: AND ORGANIZATION_ID = i_org_id );
713:
714:

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: WIP_REPETITIVE_SCHEDULES s,
751: ORG_ACCT_PERIODS oap
752: WHERE i.group_id = l_group_id

Line 765: | Copy rows from wip_cost_txn_interface to wip_transactions

761: AND oap.organization_id = i_org_id)
762: ;
763:
764: /*---------------------------------------------------------------+
765: | Copy rows from wip_cost_txn_interface to wip_transactions
766: | and delete from wip_cost_txn_interface
767: +---------------------------------------------------------------*/
768: l_status := CSTPWCPX.CMLCPX(l_group_id,i_org_id,5,i_user_id,i_login_id,-1,-1,-1,err_buf);
769: IF l_status <> 0 THEN

Line 766: | and delete from wip_cost_txn_interface

762: ;
763:
764: /*---------------------------------------------------------------+
765: | Copy rows from wip_cost_txn_interface to wip_transactions
766: | and delete from wip_cost_txn_interface
767: +---------------------------------------------------------------*/
768: l_status := CSTPWCPX.CMLCPX(l_group_id,i_org_id,5,i_user_id,i_login_id,-1,-1,-1,err_buf);
769: IF l_status <> 0 THEN
770: RAISE cmlcpx_status;