DBA Data[Home] [Help]

APPS.EAM_LINEAR_LOCATIONS_PUB dependencies on WIP_ENTITIES

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