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 988: FROM wip_discrete_jobs wdj

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

Line 1342: wip_discrete_jobs wdj,

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