DBA Data[Home] [Help]

APPS.EAM_LINEAR_LOCATIONS_PUB dependencies on MFG_LOOKUPS

Line 144: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name

140: -- API body
141:
142: -- Validation of external_source_name
143: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
144: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
145: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
146:
147: IF (l_count = 0) THEN
148: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

Line 279: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name

275: END IF;
276:
277: -- Validation of external_source_name
278: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
279: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
280: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
281:
282: IF (l_count = 0) THEN
283: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

Line 394: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name

390: -- API body
391:
392: -- Validation of external_source_name
393: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
394: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
395: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
396:
397: IF (l_count = 0) THEN
398: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

Line 1225: from org_access_view oav, mfg_lookups ml, mfg_lookups ml1,

1221: we.wip_entity_name work_order, wewr.description description,
1222: wewr.expected_resolution_date expected_resolution_date,
1223: ml2.meaning work_request_type, wewr.phone_number phone_number,
1224: wewr.e_mail e_mail, wewr.contact_preference contact_preference
1225: from org_access_view oav, mfg_lookups ml, mfg_lookups ml1,
1226: mfg_lookups ml2, wip_eam_work_requests wewr, wip_entities we,
1227: bom_departments bd
1228: where wewr.work_request_id = p_work_request_id
1229: and oav.organization_id = wewr.organization_id

Line 1226: mfg_lookups ml2, wip_eam_work_requests wewr, wip_entities we,

1222: wewr.expected_resolution_date expected_resolution_date,
1223: ml2.meaning work_request_type, wewr.phone_number phone_number,
1224: wewr.e_mail e_mail, wewr.contact_preference contact_preference
1225: from org_access_view oav, mfg_lookups ml, mfg_lookups ml1,
1226: mfg_lookups ml2, wip_eam_work_requests wewr, wip_entities we,
1227: bom_departments bd
1228: where wewr.work_request_id = p_work_request_id
1229: and oav.organization_id = wewr.organization_id
1230: and oav.resp_application_id = appl

Line 1465: FROM wip_discrete_jobs wdj, wip_entities we, mfg_lookups ml

1461: , x_work_order_rec.material_issue_by_mo
1462: , x_work_order_rec.source_line_id
1463: , x_work_order_rec.source_code
1464: , x_work_order_rec.issue_zero_cost_flag
1465: FROM wip_discrete_jobs wdj, wip_entities we, mfg_lookups ml
1466: WHERE wdj.wip_entity_id = we.wip_entity_id
1467: AND wdj.organization_id = we.organization_id
1468: AND wdj.wip_entity_id = p_wip_entity_id
1469: AND wdj.status_type = ml.lookup_code