DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on WIP_ENTITIES

Line 96: wip_entities we

92: decode(l_bom_rev_basis,2,l_new_rev_date_bom,wdj.bom_revision_date) bom_revision_date,--12.1 Routing/BOM Revision Date Refresh Programme
93: wdj.wip_supply_type,
94: wdj.status_type
95: FROM wip_discrete_jobs wdj,
96: wip_entities we
97: WHERE we.organization_id = p_org_id
98: AND we.organization_id = wdj.organization_id
99: AND we.wip_entity_id = wdj.wip_entity_id
100: AND we.entity_type in (5, 8)

Line 364: wip_entities we

360: IF (g_debug = 'Y') THEN
361: SELECT count(*)
362: INTO l_count
363: FROM wip_discrete_jobs wdj,
364: wip_entities we
365: WHERE we.organization_id = p_org_id
366: AND we.organization_id = wdj.organization_id
367: AND we.wip_entity_id = wdj.wip_entity_id
368: AND we.entity_type in (5, 8)