DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_TRANSACTIONS

Line 878: FROM WIP_TRANSACTIONS wt,

874: SELECT WIP_ENTITY_NAME
875: FROM WIP_DJ_CLOSE_TEMP
876: WHERE WIP_ENTITY_ID IN
877: (SELECT wdct.WIP_ENTITY_ID
878: FROM WIP_TRANSACTIONS wt,
879: WIP_DJ_CLOSE_TEMP wdct
880: WHERE wdct.GROUP_ID = p_group_id
881: AND wdct.ORGANIZATION_ID = p_organization_id
882: AND wdct.WIP_ENTITY_ID = wt.WIP_ENTITY_ID

Line 2093: SELECT WIP_TRANSACTIONS_S.nextval

2089: * Costing Function updates *
2090: * *
2091: ******************************************/
2092:
2093: SELECT WIP_TRANSACTIONS_S.nextval
2094: INTO l_costing_group_id
2095: FROM DUAL;
2096:
2097: INSERT INTO WIP_COST_TXN_INTERFACE

Line 2128: WIP_TRANSACTIONS_S.nextval,

2124: fnd_global.conc_request_id ,
2125: fnd_global.prog_appl_id,
2126: fnd_global.conc_program_id ,
2127: SYSDATE,
2128: WIP_TRANSACTIONS_S.nextval,
2129: oap.ACCT_PERIOD_ID,
2130: l_costing_group_id,
2131: 2, -- PROCESS_STATUS
2132: 3, -- PROCESS_PHASE