DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on WIP_ENTITIES

Line 100: wip_entities we

96: decode(l_bom_rev_basis,2,l_new_rev_date_bom,wdj.bom_revision_date) bom_revision_date,
97: wdj.wip_supply_type,
98: wdj.status_type
99: FROM wip_discrete_jobs wdj,
100: wip_entities we
101: WHERE we.organization_id = p_org_id
102: AND we.organization_id = wdj.organization_id
103: AND we.wip_entity_id = wdj.wip_entity_id
104: AND we.entity_type in (5, 8)

Line 334: wip_entities we

330: IF (g_debug = 'Y') THEN
331: SELECT count(*)
332: INTO l_count
333: FROM wip_discrete_jobs wdj,
334: wip_entities we
335: WHERE we.organization_id = p_org_id
336: AND we.organization_id = wdj.organization_id
337: AND we.wip_entity_id = wdj.wip_entity_id
338: AND we.entity_type in (5, 8)