APPS.GMI_RESERVATION_PVT dependencies on IC_WHSE_MST

Line 507: from ic_whse_mst

503: --B1766055 - Retrieve whse loct_ctl data using primary key
504: --========================================================
505: Cursor get_whse_ctl IS
506: select loct_ctl
507: from ic_whse_mst
508: where whse_code = l_allocation_rec.whse_code;
509: -- end fabdi
510: CURSOR check_detailed_allocations IS
511: SELECT SUM(ABS(trans_qty))

Line 1496: From ic_whse_mst

1492: Where line_id = l_line_id;
1493:
1494: Cursor get_whse_code(l_organization_id IN NUMBER) IS
1495: Select whse_code
1496: From ic_whse_mst
1497: Where mtl_organization_id = l_organization_id;
1498:
1499: l_organization_id NUMBER;
1500: l_whse_code VARCHAR2(5);

Line 1941: FROM IC_WHSE_MST

1937:
1938: -- Get whse information
1939: CURSOR get_whse_code (l_organization_id NUMBER ) IS
1940: SELECT whse_code ,loct_ctl
1941: FROM IC_WHSE_MST
1942: WHERE mtl_organization_id = l_organization_id ;
1943:
1944: -- Get item ctl
1945: CURSOR get_item_ctl IS

Line 2488: FROM IC_WHSE_MST

2484:
2485: -- Get whse information
2486: CURSOR get_whse_code (l_organization_id NUMBER ) IS
2487: SELECT whse_code
2488: FROM IC_WHSE_MST
2489: WHERE mtl_organization_id = l_organization_id ;
2490:
2491: -- get grade_ctl
2492: Cursor get_grade_ctl IS

Line 2734: FROM ic_whse_mst

2730:
2731: -- Get whse information
2732: CURSOR get_whse_code (l_organization_id NUMBER ) IS
2733: SELECT whse_code ,loct_ctl
2734: FROM ic_whse_mst
2735: WHERE mtl_organization_id = l_organization_id ;
2736:
2737: -- Get item ctl
2738: CURSOR get_item_ctl IS