DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on WIP_REPETITIVE_SCHEDULES

Line 1277: FROM wip_repetitive_schedules wrs,

1273: )
1274: )
1275: - quantity_completed)
1276: INTO l_qty
1277: FROM wip_repetitive_schedules wrs,
1278: wip_repetitive_items wri
1279: WHERE wrs.organization_id = p_org_id
1280: AND wrs.status_type IN (1,3,4,6)
1281: AND wri.organization_id = p_org_id

Line 1293: print_debug('Supply from WIP repetitive schedules: ' || to_char(l_qty)

1289: )
1290: - quantity_completed) > 0;
1291:
1292: IF G_TRACE_ON = 1 THEN
1293: print_debug('Supply from WIP repetitive schedules: ' || to_char(l_qty)
1294: , 'get_supply_qty'
1295: , 9);
1296: END IF;
1297:

Line 2089: from wip_repetitive_schedules r, wip_requirement_operations o

2085: --
2086: /*4518296*/
2087: select sum(o.required_quantity - o.quantity_issued)
2088: into qty
2089: from wip_repetitive_schedules r, wip_requirement_operations o
2090: where o.wip_entity_id = r.wip_entity_id
2091: and o.repetitive_schedule_id = r.repetitive_schedule_id
2092: and o.organization_id = r.organization_id
2093: and r.organization_id = p_org_id