APPS.EAM_MATERIALISSUE_PVT dependencies on WIP_DISCRETE_JOBS

Line 173: from wip_discrete_jobs where

169: end if;
170:
171: select nvl(material_issue_by_mo,'Y'), project_id, task_id
172: into l_material_issue_by_mo, l_project_id, l_task_id
173: from wip_discrete_jobs where
174: wip_entity_id=p_wip_entity_id
175: and organization_id=p_organization_id;
176: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
177: 'l_material_issue_by_mo=' || l_material_issue_by_mo);

Line 1234: from wip_discrete_jobs wdj, wip_entities we

1230: wdj.status_type
1231: into l_project_id,
1232: l_task_id,
1233: l_status_type
1234: from wip_discrete_jobs wdj, wip_entities we
1235: where wdj.wip_entity_id = we.wip_entity_id
1236: and wdj.organization_id = we.organization_id
1237: and wdj.organization_id = l_organization_id
1238: and wdj.wip_entity_id = l_wip_entity_id;

Line 1461: from wip_discrete_jobs wdj, wip_entities we

1457: wdj.status_type
1458: into l_project_id,
1459: l_task_id,
1460: l_status_type
1461: from wip_discrete_jobs wdj, wip_entities we
1462: where wdj.wip_entity_id = we.wip_entity_id
1463: and wdj.organization_id = we.organization_id
1464: and wdj.organization_id = l_organization_id
1465: and wdj.wip_entity_id = l_wip_entity_id;

Line 1625: from wip_discrete_jobs

1621:
1622: if (p_status_type = 3) then -- Work Order is Released
1623:
1624: select project_id, task_id into l_project_id, l_task_id
1625: from wip_discrete_jobs
1626: where wip_entity_id = p_wip_entity_id
1627: and organization_id=p_organization_id;
1628:
1629: l_allocate_rec.wip_entity_id := l_wip_entity_id;