DBA Data[Home] [Help]

APPS.WIP_REQUIREMENT_DEFAULT dependencies on WIP_DISCRETE_JOBS

Line 53: FROM WIP_DISCRETE_JOBS

49: begin
50: /* derive p_required_quantity, p_MPS_required_quantity */
51: SELECT start_quantity, scheduled_start_date
52: INTO X_start_quantity, x_scheduled_start_date
53: FROM WIP_DISCRETE_JOBS
54: WHERE wip_entity_id = p_wip_entity_id
55: AND organization_id = p_organization_id;
56:
57: x_state_num := x_state_num + 1;

Line 125: wip_discrete_jobs wdj

121: /* MRP_net_flag */
122: select wdj.wip_supply_type, wdj.job_type, we.entity_type
123: into X_temp_wip_supply_type, X_job_type, X_entity_type
124: from wip_entities we,
125: wip_discrete_jobs wdj
126: where wdj.wip_entity_id = p_wip_entity_id
127: and wdj.organization_id = p_organization_id
128: and wdj.wip_entity_id = we.wip_entity_id
129: and wdj.organization_id = we.organization_id ;