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 97: FROM mtl_cycle_count_entries

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

Line 148: FROM mtl_cycle_count_entries

144: BEGIN
145: -- Calculate the next value for the count list sequence
146: SELECT NVL ( MAX ( count_list_sequence ), 0 ) + 1
147: INTO l_count_list_sequence
148: FROM mtl_cycle_count_entries
149: WHERE cycle_count_header_id = p_cycle_count_header_id
150: AND organization_id = p_organization_id;
151:
152: -- Update this value for the cycle count header

Line 189: FROM mtl_cycle_count_entries

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

Line 205: FROM mtl_cycle_count_entries

201:
202: CURSOR cc_multiple_serial_cursor
203: IS
204: SELECT *
205: FROM mtl_cycle_count_entries
206: WHERE cycle_count_header_id = p_cycle_count_header_id
207: AND organization_id = p_organization_id
208: AND subinventory = p_subinventory
209: AND NVL ( locator_id, -99999 ) = NVL ( p_locator_id, -99999 )

Line 219: FROM mtl_cycle_count_entries

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

Line 233: FROM mtl_cycle_count_entries

229:
230: CURSOR cc_discrepant_multiple_cursor
231: IS
232: SELECT *
233: FROM mtl_cycle_count_entries
234: WHERE cycle_count_header_id = p_cycle_count_header_id
235: AND organization_id = p_organization_id
236: AND NVL ( parent_lpn_id, -99999 ) = NVL ( p_parent_lpn_id, -99999 )
237: AND inventory_item_id = p_inventory_item_id

Line 249: FROM mtl_cycle_count_entries

245: -- to allow for location discrepancies as well as rev, lot, and LPN
246: CURSOR cc_discrepant_serial_cursor
247: IS
248: SELECT *
249: FROM mtl_cycle_count_entries
250: WHERE cycle_count_header_id = p_cycle_count_header_id
251: AND organization_id = p_organization_id
252: AND inventory_item_id = p_inventory_item_id
253: AND serial_number = NVL ( l_current_serial, '@@@@@' )

Line 376: FROM mtl_cycle_count_entries

372:
373: BEGIN
374: SELECT MIN ( cycle_count_entry_id )
375: INTO l_dispatched_task
376: FROM mtl_cycle_count_entries
377: WHERE cycle_count_header_id = p_cycle_count_header_id
378: AND organization_id = p_organization_id
379: AND subinventory = p_subinventory
380: AND NVL ( locator_id, -99999 ) = NVL ( p_locator_id, -99999 )

Line 933: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt

929:
930: CURSOR cc_entry_cursor
931: IS
932: SELECT cycle_count_entry_id
933: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt
934: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
935: AND mcce.cycle_count_entry_id = wdt.transaction_temp_id
936: AND mcce.organization_id = p_organization_id
937: AND mcce.subinventory = p_subinventory

Line 1145: INSERT INTO mtl_cycle_count_entries

1141: g_cc_entry.SECONDARY_SYSTEM_QTY_CURRENT:=round(g_cc_entry.SECONDARY_SYSTEM_QTY_CURRENT,5);
1142:
1143:
1144: --bug fix 7429096 kbanddyo added few columns in the insert statement related to sec qty .
1145: INSERT INTO mtl_cycle_count_entries
1146: ( cycle_count_entry_id,
1147: last_update_date,
1148: last_updated_by,
1149: creation_date,

Line 1403: UPDATE mtl_cycle_count_entries

1399: ELSE
1400: g_cc_entry.outermost_lpn_id := NULL;
1401: END IF;
1402:
1403: UPDATE mtl_cycle_count_entries
1404: SET last_update_date = g_cc_entry.last_update_date,
1405: last_updated_by = g_cc_entry.last_updated_by,
1406: last_update_login = g_cc_entry.last_update_login,
1407: count_list_sequence = g_cc_entry.count_list_sequence,

Line 1958: FROM mtl_cycle_count_entries_v

1954: parent_lpn_id
1955: INTO l_pos_meas_err,
1956: l_neg_meas_err,
1957: l_parent_lpn_id
1958: FROM mtl_cycle_count_entries_v
1959: WHERE cycle_count_entry_id = g_cc_entry.cycle_count_entry_id
1960: AND organization_id = g_cc_entry.organization_id;
1961: EXCEPTION
1962: WHEN NO_DATA_FOUND THEN

Line 2358: SELECT mtl_cycle_count_entries_s.NEXTVAL

2354: END IF;
2355: g_cc_entry.serial_detail := l_serial_detail;
2356:
2357: IF ( g_cc_entry.cycle_count_entry_id IS NULL ) THEN
2358: SELECT mtl_cycle_count_entries_s.NEXTVAL
2359: INTO l_cc_entry_id
2360: FROM DUAL;
2361:
2362: g_cc_entry.cycle_count_entry_id := l_cc_entry_id;

Line 2747: FROM mtl_cycle_count_entries

2743: -- Compare the current entry's number of counts with the value
2744: -- in the record stored in the table
2745: SELECT NVL ( number_of_counts, 0 )
2746: INTO l_old_num_counts
2747: FROM mtl_cycle_count_entries
2748: WHERE cycle_count_entry_id = l_cc_entry_id;
2749:
2750: IF ( l_old_num_counts > l_number_of_counts ) THEN
2751: FND_MESSAGE.SET_NAME ( 'INV', 'INV_DUPLICATE_COUNT_UPDATE' );

Line 4207: FROM mtl_cycle_count_entries

4203: END IF;
4204:
4205: SELECT COUNT ( * )
4206: INTO l_count
4207: FROM mtl_cycle_count_entries
4208: WHERE cycle_count_header_id = l_cc_header_id
4209: AND organization_id = l_org_id
4210: AND inventory_item_id = l_item_id
4211: AND subinventory = l_sub

Line 4259: FROM MTL_CYCLE_COUNT_ENTRIES_V

4255: IS
4256: SELECT cycle_count_entry_id,
4257: entry_status_code,
4258: inventory_item_id
4259: FROM MTL_CYCLE_COUNT_ENTRIES_V
4260: WHERE cycle_count_header_id = l_cc_header_id
4261: -- AND nvl(export_flag,2) = 2
4262: AND serial_number_control_code IN ( 2, 5 );
4263:

Line 4782: SELECT mtl_cycle_count_entries_s.NEXTVAL

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

Line 5605: FROM mtl_cycle_count_entries

5601: DELETE FROM mtl_cc_Serial_numbers
5602: WHERE serial_number = p_serial_number
5603: AND cycle_count_entry_id IN
5604: (SELECT cycle_count_entry_id
5605: FROM mtl_cycle_count_entries
5606: WHERE cycle_Count_header_id = p_cc_header_id
5607: AND entry_status_code IN (1,3))
5608: AND cycle_count_entry_id <> p_cycle_Count_entry_id;
5609:

Line 7208: FROM mtl_cycle_count_entries

7204: SELECT NVL ( serial_number, '@@@@@' ),
7205: inventory_item_id
7206: INTO l_current_serial,
7207: l_current_item
7208: FROM mtl_cycle_count_entries
7209: WHERE cycle_count_entry_id = cycle_cnt_entry_id;
7210:
7211: -- Old call to serial_check.inv_unmark_serial
7212: --g1 := NULL;

Line 8520: FROM mtl_cycle_count_entries

8516: END IF;
8517:
8518: SELECT COUNT ( * )
8519: INTO x_count
8520: FROM mtl_cycle_count_entries
8521: WHERE cycle_count_header_id = p_cycle_count_header_id
8522: AND entry_status_code IN ( 1, 3 )
8523: AND NVL ( export_flag, 2 ) = 2;
8524: END get_scheduled_entry;

Line 9361: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

9357: print_debug('Checking schduled serial CCs..' );
9358: SELECT COUNT(*)
9359: INTO x_scheduled_qty
9360: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
9361: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
9362: WHERE msn.inventory_item_id = p_inventory_item_id
9363: AND msn.current_organization_id = p_organization_id
9364: AND msn.current_status IN (1, 3)
9365: AND msn.status_id = mms.status_id(+)

Line 9378: AND EXISTS (select 1 from mtl_cycle_count_entries

9374: AND NVL(mcce.lot_number, '###' ) = NVL(p_lot_number, '###')
9375: AND NVL(mcce.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
9376: AND mcce.entry_status_code IN (1, 3)
9377: AND NVL(mcce.export_flag, 2) = 2
9378: AND EXISTS (select 1 from mtl_cycle_count_entries
9379: where cycle_count_entry_id = mcce.cycle_count_entry_id
9380: and number_of_counts is null);
9381:
9382: IF x_scheduled_qty is null or x_scheduled_qty = 0 THEN

Line 9385: FROM mtl_cycle_count_entries mcce

9381:
9382: IF x_scheduled_qty is null or x_scheduled_qty = 0 THEN
9383: SELECT mcce.system_quantity_current
9384: INTO x_scheduled_qty
9385: FROM mtl_cycle_count_entries mcce
9386: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
9387: AND mcce.inventory_item_id = p_inventory_item_id
9388: AND mcce.organization_id = p_organization_id
9389: AND mcce.subinventory = p_subinventory

Line 9448: FROM mtl_cycle_count_entries

9444: WHERE wdt.person_id = l_employee_id
9445: AND wdt.task_type = 3
9446: AND NOT EXISTS (
9447: SELECT 'ACTIVE_TASK'
9448: FROM mtl_cycle_count_entries
9449: WHERE entry_status_code in (1,3)
9450: AND NVL(export_flag,2) = 2
9451: AND cycle_count_entry_id = wdt.transaction_temp_id );--bug 12614348
9452:

Line 9686: FROM mtl_cycle_count_entries

9682:
9683:
9684: SELECT Min(CYCLE_COUNT_ENTRY_ID)
9685: INTO l_cc_id
9686: FROM mtl_cycle_count_entries
9687: WHERE organization_id = p_organization_id
9688: AND cycle_count_header_id = p_cc_header_id
9689: AND entry_status_code IN (1,3)
9690: AND inventory_item_id = p_inventory_item_id

Line 9963: FROM mtl_cycle_count_entries

9959: print_debug('l_progress = ' || l_progress);
9960:
9961: SELECT min(cycle_count_entry_id)
9962: INTO l_transaction_temp_id
9963: FROM mtl_cycle_count_entries
9964: WHERE organization_id = p_organization_id
9965: AND cycle_count_header_id = p_cc_header_id
9966: AND entry_status_code IN (1,3)
9967: AND inventory_item_id = p_item_id

Line 9979: from mtl_cycle_count_entries

9975: END IF;
9976:
9977: SELECT nvl(standard_operation_id,0),nvl(task_priority,0)
9978: INTO l_standard_operation_id,l_task_priority
9979: from mtl_cycle_count_entries
9980: WHERE cycle_count_entry_id = l_transaction_temp_id;
9981:
9982: BEGIN
9983:

Line 10336: mtl_serial_numbers, mtl_cycle_count_entries will be updated and the out parameter x_return_result will

10332: This procedure will do the processing for a cycle count with header details as "Multiple Per Request"
10333: Count and "Quantity Only" Detail in which the count quantity is equal to system quantity.
10334:
10335: If count quantity is equal to system quantity, the relevant tables like mtl_cc_serial_numbers,
10336: mtl_serial_numbers, mtl_cycle_count_entries will be updated and the out parameter x_return_result will
10337: have the value 1.
10338:
10339: In case count quantity is not equal to system quantity (or there are other discrepancies), this procedure
10340: will not perform any logic and x_return_result will be set equal to 2.

Line 10530: -- to update cycle count's record in mtl_cycle_count_entries table

10526: );
10527:
10528: END IF;
10529:
10530: -- to update cycle count's record in mtl_cycle_count_entries table
10531: update_row();
10532: x_return_result := 1;
10533: RETURN;
10534: