DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on WIP_REPETITIVE_SCHEDULES

Line 1328: FROM wip_repetitive_schedules wrs,

1324: GREATEST(0, LEAST(processing_work_days,
1325: p_s_cutoff - first_unit_completion_date))
1326: - quantity_completed)
1327: INTO l_qty
1328: FROM wip_repetitive_schedules wrs,
1329: wip_repetitive_items wri
1330: WHERE wrs.organization_id = p_org_id
1331: AND wrs.status_type IN (1,3,4,6)
1332: AND wri.organization_id = p_org_id

Line 1854: from wip_repetitive_schedules r, wip_requirement_operations o

1850: -- Bug#691471
1851: --
1852: select sum(o.required_quantity - o.quantity_issued)
1853: into qty
1854: from wip_repetitive_schedules r, wip_requirement_operations o
1855: where o.wip_entity_id = r.wip_entity_id
1856: and o.repetitive_schedule_id = r.repetitive_schedule_id
1857: and o.organization_id = r.organization_id
1858: and r.organization_id = p_org_id