DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on IC_LOCT_MST

Line 156: FROM ic_loct_mst

152: /* hwahdani BUG#:1495550 get proper value of default location from profile */
153: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
154: ELSE
155: SELECT location INTO l_location
156: FROM ic_loct_mst
157: WHERE inventory_location_id = p_shipping_line.locator_id;
158: END IF;
159:
160: IF p_shipping_line.lot_number IS NULL

Line 879: FROM ic_loct_mst

875: /* hwahdani BUG#:1495550 get proper value of default location from profile */
876: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
877: ELSE
878: SELECT location INTO l_location
879: FROM ic_loct_mst
880: WHERE inventory_location_id = p_shipping_line.locator_id;
881: END IF;
882:
883: GMI_RESERVATION_UTIL.println('LOT_NUMBER => ' || p_shipping_line.lot_number);

Line 2096: FROM ic_loct_mst

2092: THEN
2093: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
2094: ELSE
2095: SELECT location INTO l_location
2096: FROM ic_loct_mst
2097: WHERE inventory_location_id = p_locator_id;
2098: END IF;
2099:
2100: GMI_RESERVATION_UTIL.println('LOT_NUMBER => ' || p_lot_number);

Line 3239: FROM ic_loct_mst

3235: THEN
3236: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
3237: ELSE
3238: SELECT location INTO l_location
3239: FROM ic_loct_mst
3240: WHERE inventory_location_id = lines.locator_id;
3241: END IF;
3242: IF lines.lot_number IS NULL
3243: THEN