DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_TRANSACTIONS

Line 1145: FROM WIP_TRANSACTIONS wt,

1141: SELECT WIP_ENTITY_NAME
1142: FROM WIP_DJ_CLOSE_TEMP
1143: WHERE WIP_ENTITY_ID IN
1144: (SELECT wdct.WIP_ENTITY_ID
1145: FROM WIP_TRANSACTIONS wt,
1146: WIP_DJ_CLOSE_TEMP wdct
1147: WHERE wdct.GROUP_ID = p_group_id
1148: AND wdct.ORGANIZATION_ID = p_organization_id
1149: AND wdct.WIP_ENTITY_ID = wt.WIP_ENTITY_ID

Line 2594: SELECT WIP_TRANSACTIONS_S.nextval

2590: ******************************************/
2591:
2592: SAVEPOINT wip_close; --Bug#13639508- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back
2593:
2594: SELECT WIP_TRANSACTIONS_S.nextval
2595: INTO l_costing_group_id
2596: FROM DUAL;
2597:
2598: INSERT INTO WIP_COST_TXN_INTERFACE

Line 2629: WIP_TRANSACTIONS_S.nextval,

2625: fnd_global.conc_request_id ,
2626: fnd_global.prog_appl_id,
2627: fnd_global.conc_program_id ,
2628: SYSDATE,
2629: WIP_TRANSACTIONS_S.nextval,
2630: oap.ACCT_PERIOD_ID,
2631: l_costing_group_id,
2632: 2, -- PROCESS_STATUS
2633: 3, -- PROCESS_PHASE