eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CYC_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 92: FROM mtl_cycle_count_entries

88: AND trunc(nvl(disable_date, sysdate+1)) > trunc(sysdate) --Changed for bug 5519506
89: AND cycle_count_header_name LIKE ( p_cycle_count )
90: AND ( ( cycle_count_header_id IN (
91: SELECT UNIQUE cycle_count_header_id
92: FROM mtl_cycle_count_entries
93: WHERE organization_id = p_organization_id
94: AND entry_status_code IN ( 1, 3 ) )
95: )
96: OR NVL ( unscheduled_count_entry, 2 ) = 1

Line 133: FROM mtl_cycle_count_entries

129: BEGIN
130: -- Calculate the next value for the count list sequence
131: SELECT NVL ( MAX ( count_list_sequence ), 0 ) + 1
132: INTO l_count_list_sequence
133: FROM mtl_cycle_count_entries
134: WHERE cycle_count_header_id = p_cycle_count_header_id
135: AND organization_id = p_organization_id;
136:
137: -- Update this value for the cycle count header

Line 174: FROM mtl_cycle_count_entries

170:
171: CURSOR cc_entry_cursor
172: IS
173: SELECT *
174: FROM mtl_cycle_count_entries
175: WHERE cycle_count_header_id = p_cycle_count_header_id
176: AND organization_id = p_organization_id
177: AND subinventory = p_subinventory
178: AND NVL ( locator_id, -99999 ) = NVL ( p_locator_id, -99999 )

Line 190: FROM mtl_cycle_count_entries

186:
187: CURSOR cc_multiple_serial_cursor
188: IS
189: SELECT *
190: FROM mtl_cycle_count_entries
191: WHERE cycle_count_header_id = p_cycle_count_header_id
192: AND organization_id = p_organization_id
193: AND subinventory = p_subinventory
194: AND NVL ( locator_id, -99999 ) = NVL ( p_locator_id, -99999 )

Line 204: FROM mtl_cycle_count_entries

200:
201: CURSOR cc_discrepant_cursor
202: IS
203: SELECT *
204: FROM mtl_cycle_count_entries
205: WHERE cycle_count_header_id = p_cycle_count_header_id
206: AND organization_id = p_organization_id
207: AND NVL ( parent_lpn_id, -99999 ) = NVL ( p_parent_lpn_id, -99999 )
208: AND inventory_item_id = p_inventory_item_id

Line 218: FROM mtl_cycle_count_entries

214:
215: CURSOR cc_discrepant_multiple_cursor
216: IS
217: SELECT *
218: FROM mtl_cycle_count_entries
219: WHERE cycle_count_header_id = p_cycle_count_header_id
220: AND organization_id = p_organization_id
221: AND NVL ( parent_lpn_id, -99999 ) = NVL ( p_parent_lpn_id, -99999 )
222: AND inventory_item_id = p_inventory_item_id

Line 234: FROM mtl_cycle_count_entries

230: -- to allow for location discrepancies as well as rev, lot, and LPN
231: CURSOR cc_discrepant_serial_cursor
232: IS
233: SELECT *
234: FROM mtl_cycle_count_entries
235: WHERE cycle_count_header_id = p_cycle_count_header_id
236: AND organization_id = p_organization_id
237: AND inventory_item_id = p_inventory_item_id
238: AND serial_number = NVL ( l_current_serial, '@@@@@' )

Line 320: FROM mtl_cycle_count_entries

316:
317: BEGIN
318: SELECT MIN ( cycle_count_entry_id )
319: INTO l_dispatched_task
320: FROM mtl_cycle_count_entries
321: WHERE cycle_count_header_id = p_cycle_count_header_id
322: AND organization_id = p_organization_id
323: AND subinventory = p_subinventory
324: AND NVL ( locator_id, -99999 ) = NVL ( p_locator_id, -99999 )

Line 843: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt

839:
840: CURSOR cc_entry_cursor
841: IS
842: SELECT cycle_count_entry_id
843: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt
844: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
845: AND mcce.cycle_count_entry_id = wdt.transaction_temp_id
846: AND mcce.organization_id = p_organization_id
847: AND mcce.subinventory = p_subinventory

Line 971: INSERT INTO mtl_cycle_count_entries

967: ELSE
968: g_cc_entry.outermost_lpn_id := NULL;
969: END IF;
970:
971: INSERT INTO mtl_cycle_count_entries
972: ( cycle_count_entry_id,
973: last_update_date,
974: last_updated_by,
975: creation_date,

Line 1207: UPDATE mtl_cycle_count_entries

1203: ELSE
1204: g_cc_entry.outermost_lpn_id := NULL;
1205: END IF;
1206:
1207: UPDATE mtl_cycle_count_entries
1208: SET last_update_date = g_cc_entry.last_update_date,
1209: last_updated_by = g_cc_entry.last_updated_by,
1210: last_update_login = g_cc_entry.last_update_login,
1211: count_list_sequence = g_cc_entry.count_list_sequence,

Line 1722: FROM mtl_cycle_count_entries_v

1718: parent_lpn_id
1719: INTO l_pos_meas_err,
1720: l_neg_meas_err,
1721: l_parent_lpn_id
1722: FROM mtl_cycle_count_entries_v
1723: WHERE cycle_count_entry_id = g_cc_entry.cycle_count_entry_id
1724: AND organization_id = g_cc_entry.organization_id;
1725: EXCEPTION
1726: WHEN NO_DATA_FOUND THEN

Line 2111: SELECT mtl_cycle_count_entries_s.NEXTVAL

2107: l_serial_detail := l_serial_detail_option;
2108: g_cc_entry.serial_detail := l_serial_detail;
2109:
2110: IF ( g_cc_entry.cycle_count_entry_id IS NULL ) THEN
2111: SELECT mtl_cycle_count_entries_s.NEXTVAL
2112: INTO l_cc_entry_id
2113: FROM DUAL;
2114:
2115: g_cc_entry.cycle_count_entry_id := l_cc_entry_id;

Line 2500: FROM mtl_cycle_count_entries

2496: -- Compare the current entry's number of counts with the value
2497: -- in the record stored in the table
2498: SELECT NVL ( number_of_counts, 0 )
2499: INTO l_old_num_counts
2500: FROM mtl_cycle_count_entries
2501: WHERE cycle_count_entry_id = l_cc_entry_id;
2502:
2503: IF ( l_old_num_counts > l_number_of_counts ) THEN
2504: FND_MESSAGE.SET_NAME ( 'INV', 'INV_DUPLICATE_COUNT_UPDATE' );

Line 3894: FROM mtl_cycle_count_entries

3890: END IF;
3891:
3892: SELECT COUNT ( * )
3893: INTO l_count
3894: FROM mtl_cycle_count_entries
3895: WHERE cycle_count_header_id = l_cc_header_id
3896: AND organization_id = l_org_id
3897: AND inventory_item_id = l_item_id
3898: AND subinventory = l_sub

Line 3946: FROM MTL_CYCLE_COUNT_ENTRIES_V

3942: IS
3943: SELECT cycle_count_entry_id,
3944: entry_status_code,
3945: inventory_item_id
3946: FROM MTL_CYCLE_COUNT_ENTRIES_V
3947: WHERE cycle_count_header_id = l_cc_header_id
3948: -- AND nvl(export_flag,2) = 2
3949: AND serial_number_control_code IN ( 2, 5 );
3950:

Line 4447: SELECT mtl_cycle_count_entries_s.NEXTVAL

4443: END IF;
4444:
4445: IF ( l_serial_count_option = 3 ) THEN
4446: IF ( l_cycle_count_entry_id IS NULL ) THEN
4447: SELECT mtl_cycle_count_entries_s.NEXTVAL
4448: INTO l_cycle_count_entry_id
4449: FROM DUAL;
4450:
4451: g_cc_entry.cycle_count_entry_id := l_cycle_count_entry_id;

Line 4783: SELECT mtl_cycle_count_entries_s.NEXTVAL

4779: END IF;
4780:
4781: IF ( l_serial_count_option = 3 ) THEN
4782: IF ( l_cycle_count_entry_id IS NULL ) THEN
4783: SELECT mtl_cycle_count_entries_s.NEXTVAL
4784: INTO l_cycle_count_entry_id
4785: FROM DUAL;
4786:
4787: g_cc_entry.cycle_count_entry_id := l_cycle_count_entry_id;

Line 5506: FROM mtl_cycle_count_entries

5502: DELETE FROM mtl_cc_Serial_numbers
5503: WHERE serial_number = p_serial_number
5504: AND cycle_count_entry_id IN
5505: (SELECT cycle_count_entry_id
5506: FROM mtl_cycle_count_entries
5507: WHERE cycle_Count_header_id = p_cc_header_id
5508: AND entry_status_code IN (1,3))
5509: AND cycle_count_entry_id <> p_cycle_Count_entry_id;
5510:

Line 7099: FROM mtl_cycle_count_entries

7095: SELECT NVL ( serial_number, '@@@@@' ),
7096: inventory_item_id
7097: INTO l_current_serial,
7098: l_current_item
7099: FROM mtl_cycle_count_entries
7100: WHERE cycle_count_entry_id = cycle_cnt_entry_id;
7101:
7102: -- Old call to serial_check.inv_unmark_serial
7103: --g1 := NULL;

Line 8301: FROM mtl_cycle_count_entries

8297: END IF;
8298:
8299: SELECT COUNT ( * )
8300: INTO x_count
8301: FROM mtl_cycle_count_entries
8302: WHERE cycle_count_header_id = p_cycle_count_header_id
8303: AND entry_status_code IN ( 1, 3 )
8304: AND NVL ( export_flag, 2 ) = 2;
8305: END get_scheduled_entry;