DBA Data[Home] [Help]

APPS.WMS_CYCLE_PVT dependencies on MTL_CYCLE_COUNT_HEADERS

Line 147: FROM mtl_cycle_count_headers

143:
144: /* Check that unscheduled counts are allowed */
145: SELECT unscheduled_count_entry
146: INTO l_unscheduled_count_entry
147: FROM mtl_cycle_count_headers
148: WHERE cycle_count_header_id = l_cycle_count_header_id
149: AND organization_id = p_organization_id;
150: IF (l_unscheduled_count_entry = 2) THEN
151: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_UNSCHED_COUNTS');

Line 173: FROM mtl_cycle_count_headers

169: /* Bug 5236299 - Selecting the zero count flag for the cycle count */
170:
171: SELECT NVL(zero_count_flag,2)
172: INTO l_zero_count_flag
173: FROM mtl_cycle_count_headers
174: WHERE cycle_count_header_id = l_cycle_count_header_id
175: AND organization_id = p_organization_id;
176:
177: IF (l_debug = 1) THEN