DBA Data[Home] [Help]

APPS.EAM_ASSIGN_EMP_PUB dependencies on WIP_DISCRETE_JOBS

Line 825: wip_discrete_jobs wdj,

821: ) AS usage ,
822: woru.operation_seq_num,
823: woru.resource_seq_num
824: FROM wip_operation_resource_usage woru ,
825: wip_discrete_jobs wdj,
826: bom_resource_employees bre
827: WHERE bre.person_id = l_person_id
828: AND bre.effective_start_date <= sysdate
829: AND bre.effective_end_date > sysdate

Line 989: FROM wip_discrete_jobs wdj

985:
986: IF (p_wip_entity_id IS NOT NULL) THEN
987:
988: SELECT wdj.FIRM_PLANNED_FLAG INTO l_firm_status
989: FROM wip_discrete_jobs wdj
990: WHERE wdj.wip_entity_id = p_wip_entity_id
991: AND organization_id = p_organization_id ;
992:
993: END IF;

Line 1345: wip_discrete_jobs wdj,

1341: woru.organization_id,
1342: ppf.full_name as employee_name ,
1343: wdj.firm_planned_flag as firm_status
1344: FROM wip_operation_resource_usage woru ,
1345: wip_discrete_jobs wdj,
1346: eam_work_order_details ewod,
1347: bom_resource_employees bre,
1348: per_people_f ppf
1349: WHERE ppf.person_id = p_person_id