DBA Data[Home] [Help]

APPS.WIP_CLOSE_UTILITIES dependencies on WIP_DISCRETE_JOBS

Line 14: WIP_DISCRETE_JOBS WDJ

10: SELECT WDJ.DATE_RELEASED,
11: WDJ.DATE_COMPLETED,
12: WDJ.DATE_CLOSED
13: FROM ORG_ACCT_PERIODS OAP,
14: WIP_DISCRETE_JOBS WDJ
15: WHERE WDJ.WIP_ENTITY_ID = P_Wip_Entity_Id
16: AND WDJ.ORGANIZATION_ID = P_Organization_Id
17: AND OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
18: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (WDJ.DATE_CLOSED,

Line 83: FROM WIP_DISCRETE_JOBS WDJ,

79: ELSE
80: DECLARE CURSOR C1 IS
81: SELECT WDCT.STATUS_TYPE,
82: WDCT.rowid
83: FROM WIP_DISCRETE_JOBS WDJ,
84: WIP_DJ_CLOSE_TEMP WDCT
85: WHERE WDCT.WIP_ENTITY_ID = P_wip_entity_id
86: AND WDCT.ORGANIZATION_ID = P_organization_id
87: AND WDJ.WIP_ENTITY_ID = WDCT.WIP_ENTITY_ID