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.

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_ENTITIES

Line 83: WIP_ENTITIES WE

79: DJ.PRIMARY_ITEM_ID,
80: DJ.STATUS_TYPE
81: FROM ORG_ACCT_PERIODS AP,
82: WIP_DISCRETE_JOBS DJ,
83: WIP_ENTITIES WE
84: WHERE DJ.ORGANIZATION_ID = p_organization_id
85: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID
86: AND AP.ORGANIZATION_ID = DJ.ORGANIZATION_ID
87: AND AP.OPEN_FLAG = 'Y'

Line 201: WIP_ENTITIES WE

197: DJ.PRIMARY_ITEM_ID ,
198: DJ.STATUS_TYPE
199: FROM ORG_ACCT_PERIODS AP ,
200: WIP_DISCRETE_JOBS DJ ,
201: WIP_ENTITIES WE
202: WHERE DJ.ORGANIZATION_ID = p_organization_id
203: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID
204: AND AP.ORGANIZATION_ID = DJ.ORGANIZATION_ID
205: AND AP.OPEN_FLAG = 'Y'

Line 298: WIP_ENTITIES WE

294: x_group_id
295: BULK COLLECT INTO l_close_temp_tbl2
296: FROM ORG_ACCT_PERIODS AP,
297: WIP_DISCRETE_JOBS DJ,
298: WIP_ENTITIES WE
299: WHERE DJ.ORGANIZATION_ID = p_organization_id
300: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID
301: AND AP.ORGANIZATION_ID = DJ.ORGANIZATION_ID
302: AND AP.OPEN_FLAG = 'Y'

Line 891: wip_entities we

887: cursor c_jobs is
888: select wdct.wip_entity_id,
889: we.organization_id
890: from wip_dj_close_temp wdct,
891: wip_entities we
892: where we.wip_entity_id = wdct.wip_entity_id
893: and we.organization_id = wdct.organization_id
894: and wdct.group_id = p_group_id
895: and wdct.organization_id = p_organization_id;

Line 933: wip_entities we

929: cursor c_jobs is
930: select wdct.wip_entity_id,
931: we.wip_entity_name
932: from wip_dj_close_temp wdct,
933: wip_entities we
934: where we.wip_entity_id = wdct.wip_entity_id
935: and we.organization_id = wdct.organization_id
936: and wdct.group_id = p_group_id
937: and wdct.organization_id = p_organization_id;

Line 1034: wip_entities we

1030: select wdct.wip_entity_id,
1031: we.entity_type,
1032: we.wip_entity_name
1033: from wip_dj_close_temp wdct,
1034: wip_entities we
1035: where we.wip_entity_id = wdct.wip_entity_id
1036: and we.organization_id = wdct.organization_id
1037: and wdct.group_id = p_group_id
1038: and wdct.organization_id = p_organization_id;

Line 1090: wip_entities we

1086: cursor c_jobs is
1087: select wdct.wip_entity_id,
1088: we.entity_type
1089: from wip_dj_close_temp wdct,
1090: wip_entities we
1091: where we.wip_entity_id = wdct.wip_entity_id
1092: and we.organization_id = wdct.organization_id
1093: and wdct.group_id = p_group_id
1094: and wdct.organization_id = p_organization_id;

Line 2642: WIP_ENTITIES we

2638: we.ENTITY_TYPE,
2639: wdct.ACTUAL_CLOSE_DATE
2640: FROM WIP_DJ_CLOSE_TEMP wdct,
2641: ORG_ACCT_PERIODS oap,
2642: WIP_ENTITIES we
2643: WHERE wdct.GROUP_ID = l_group_id
2644: AND we.wip_entity_id = wdct.wip_entity_id
2645: AND we.organization_id = p_organization_id
2646: AND wdct.ORGANIZATION_ID = p_organization_id

Line 2748: UPDATE WIP_ENTITIES

2744: END;
2745: END LOOP;
2746: --End of Fix bug 15874569
2747:
2748: UPDATE WIP_ENTITIES
2749: SET ENTITY_TYPE = --DECODE(entity_type,6,7,5,8,3),
2750: DECODE(entity_type,
2751: WIP_CONSTANTS.EAM,
2752: WIP_CONSTANTS.CLOSED_EAM,