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 2099: from wip_repetitive_schedules r, wip_requirement_operations o

2095: --
2096: /*4518296*/
2097: select sum(o.required_quantity - o.quantity_issued)
2098: into qty
2099: from wip_repetitive_schedules r, wip_requirement_operations o
2100: where o.wip_entity_id = r.wip_entity_id
2101: and o.repetitive_schedule_id = r.repetitive_schedule_id
2102: and o.organization_id = r.organization_id
2103: and r.organization_id = p_org_id