APPS.EAM_MATERIALISSUE_PVT dependencies on WIP_DISCRETE_JOBS

Line 124: from wip_discrete_jobs where

120: end if;
121:
122: select nvl(material_issue_by_mo,'Y'), project_id, task_id
123: into l_material_issue_by_mo, l_project_id, l_task_id
124: from wip_discrete_jobs where
125: wip_entity_id=p_wip_entity_id
126: and organization_id=p_organization_id;
127: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
128: 'l_material_issue_by_mo=' || l_material_issue_by_mo);

Line 1007: from wip_discrete_jobs wdj, wip_entities we

1003: wdj.status_type
1004: into l_project_id,
1005: l_task_id,
1006: l_status_type
1007: from wip_discrete_jobs wdj, wip_entities we
1008: where wdj.wip_entity_id = we.wip_entity_id
1009: and wdj.organization_id = we.organization_id
1010: and wdj.organization_id = l_organization_id
1011: and wdj.wip_entity_id = l_wip_entity_id;

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 1398: from wip_discrete_jobs

1394:
1395: if (p_status_type = 3) then -- Work Order is Released
1396:
1397: select project_id, task_id into l_project_id, l_task_id
1398: from wip_discrete_jobs
1399: where wip_entity_id = p_wip_entity_id
1400: and organization_id=p_organization_id;
1401:
1402: l_allocate_rec.wip_entity_id := l_wip_entity_id;