DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on WIP_ENTITIES

Line 1580: wip_entities we

1576: select 1 into l_attach_count
1577: from dual
1578: where exists (select 1
1579: from FND_ATTACHED_DOCUMENTS fad,
1580: wip_entities we
1581: where fad.entity_name = 'MTL_SYSTEM_ITEMS'
1582: and fad.pk1_value = p_org_id
1583: and fad.pk2_value = we.primary_item_id
1584: and we.wip_entity_id= p_job_id

Line 1787: from wip_entities we

1783: end if;
1784:
1785: select we.wip_entity_name
1786: into l_job_name
1787: from wip_entities we
1788: where we.wip_entity_id = l_wip_entity_id
1789: and we.organization_id = p_org_id;
1790:
1791: select to_char(l_c_clock_date, WIP_CONSTANTS.DATETIME_FMT)