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.WMS_TASK_DISPATCH_ENGINE dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 309: mtl_cycle_count_entries and checked for disable_date value with sysdate.

305: Added condition in all the cursors selecting cycle count tasks to select
306: only those tasks whose cycle count have not been disabled by entering
307: an Inactive Date.
308: Added the table mtl_cycle_count_headers in the FROM clause and joined with
309: mtl_cycle_count_entries and checked for disable_date value with sysdate.
310: */
311:
312: -- Cursor #1 for selecting the most optimal task
313: -- 1. Sub is passed (1)

Line 380: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

376: 4 transaction_type_id,
377: 4 transaction_action_id,
378: mcce.cycle_count_header_id transaction_source_id,
379: 9 transaction_source_type_id
380: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
381: WHERE mcce.entry_status_code IN(1, 3)
382: AND NVL(mcce.export_flag, 2) = 2
383: -- bug 3972076
384: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 502: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

498: 4 transaction_type_id,
499: 4 transaction_action_id,
500: mcce.cycle_count_header_id transaction_source_id,
501: 9 transaction_source_type_id
502: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
503: WHERE mcce.entry_status_code IN(1, 3)
504: AND NVL(mcce.export_flag, 2) = 2
505: -- bug 3972076
506: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1020: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1016: 4 transaction_type_id,
1017: 4 transaction_action_id,
1018: mcce.cycle_count_header_id transaction_source_id,
1019: 9 transaction_source_type_id
1020: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1021: WHERE mcce.entry_status_code IN(1, 3)
1022: AND NVL(mcce.export_flag, 2) = 2
1023: -- bug 3972076
1024: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1098: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1094: 4 transaction_type_id,
1095: 4 transaction_action_id,
1096: mcce.cycle_count_header_id transaction_source_id,
1097: 9 transaction_source_type_id
1098: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1099: WHERE mcce.entry_status_code IN(1, 3)
1100: AND NVL(mcce.export_flag, 2) = 2
1101: -- bug 3972076
1102: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1286: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1282: 4 transaction_type_id,
1283: 4 transaction_action_id,
1284: mcce.cycle_count_header_id transaction_source_id,
1285: 9 transaction_source_type_id
1286: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1287: WHERE mcce.entry_status_code IN(1, 3)
1288: AND NVL(mcce.export_flag, 2) = 2
1289: -- bug 3972076
1290: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1409: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1405: 4 transaction_type_id,
1406: 4 transaction_action_id,
1407: mcce.cycle_count_header_id transaction_source_id,
1408: 9 transaction_source_type_id
1409: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1410: WHERE mcce.entry_status_code IN(1, 3)
1411: AND NVL(mcce.export_flag, 2) = 2
1412: -- bug 3972076
1413: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1924: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1920: 4 transaction_type_id,
1921: 4 transaction_action_id,
1922: mcce.cycle_count_header_id transaction_source_id,
1923: 9 transaction_source_type_id
1924: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1925: WHERE mcce.entry_status_code IN(1, 3)
1926: AND NVL(mcce.export_flag, 2) = 2
1927: -- bug 3972076
1928: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1996: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1992: 4 transaction_type_id,
1993: 4 transaction_action_id,
1994: mcce.cycle_count_header_id transaction_source_id,
1995: 9 transaction_source_type_id
1996: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1997: WHERE mcce.entry_status_code IN(1, 3)
1998: AND NVL(mcce.export_flag, 2) = 2
1999: -- bug 3972076
2000: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 2216: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

2212: 4 transaction_action_id,
2213: mcce.cycle_count_header_id transaction_source_id,
2214: 9 transaction_source_type_id,
2215: TO_NUMBER(NULL) parent_line_id --Added for Case Picking Project (Bulk Task check)
2216: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
2217: WHERE mcce.entry_status_code IN(1, 3)
2218: AND NVL(mcce.export_flag, 2) = 2
2219: -- bug 3972076
2220: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 2388: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

2384: mcce.cycle_count_header_id transaction_source_id,
2385: 9 transaction_source_type_id,
2386: To_number(NULL) operation_plan_id,
2387: TO_NUMBER(NULL) parent_line_id --Added for Case Picking Project (Bulk Task check)
2388: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
2389: WHERE mcce.entry_status_code IN(1, 3)
2390: AND NVL(mcce.export_flag, 2) = 2
2391: -- bug 3972076
2392: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 3089: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

3085: 4 transaction_type_id,
3086: 4 transaction_action_id,
3087: mcce.cycle_count_header_id transaction_source_id,
3088: 9 transaction_source_type_id
3089: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
3090: WHERE mcce.entry_status_code IN(1, 3)
3091: AND NVL(mcce.export_flag, 2) = 2
3092: -- bug 3972076
3093: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 3179: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

3175: 4 transaction_action_id,
3176: mcce.cycle_count_header_id transaction_source_id,
3177: 9 transaction_source_type_id,
3178: To_number(NULL) operation_plan_id
3179: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
3180: WHERE mcce.entry_status_code IN(1, 3)
3181: AND NVL(mcce.export_flag, 2) = 2
3182: -- bug 3972076
3183: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 3329: FROM mtl_cycle_count_entries

3325: FOR UPDATE nowait;
3326:
3327: CURSOR c_cycle_count_lock_check(v_cycle_count_entry_id NUMBER) IS
3328: SELECT cycle_count_entry_id
3329: FROM mtl_cycle_count_entries
3330: WHERE cycle_count_entry_id = v_cycle_count_entry_id
3331: FOR UPDATE nowait;
3332:
3333: CURSOR c_task_filter(v_filter_name VARCHAR2) IS

Line 3601: FROM mtl_cycle_count_entries

3597: TO_NUMBER(NULL) pick_slip_number,
3598: TO_NUMBER(NULL) cartonization_id,
3599: inventory_item_id,
3600: TO_NUMBER(NULL) move_order_line_id
3601: FROM mtl_cycle_count_entries
3602: WHERE entry_status_code IN(1, 3)
3603: AND NVL(export_flag, 2) = 2
3604: -- bug 3972076
3605: --AND NVL(TRUNC(count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 3615: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks

3611:
3612: -- Added the previous line since the task_id in the view
3613: -- might not be unique since it is the transaction_temp_id
3614: -- if it comes from MMTT but the cycle_count_entry_id if
3615: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks
3616: l_progress := '36';
3617: EXCEPTION
3618: WHEN OTHERS THEN
3619: -- locator definition descripency

Line 3652: -- get the location from mtl_cycle_count_entries

3648: l_cur_y := 0;
3649: l_cur_z := 0;
3650: END;
3651: ELSE -- l_last_task_type <> 3 (Cyclt Count task)
3652: -- get the location from mtl_cycle_count_entries
3653: BEGIN
3654: l_progress := '39';
3655:
3656: -- use Nvl to make sure if coordinates not defined, use 0

Line 3663: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

3659: , NVL(loc.z_coordinate, 0)
3660: INTO l_cur_x
3661: , l_cur_y
3662: , l_cur_z
3663: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
3664: WHERE mcce.locator_id = loc.inventory_location_id
3665: AND mcce.organization_id = loc.organization_id
3666: AND mcce.cycle_count_entry_id = l_last_task_id;
3667:

Line 4745: mtl_cycle_count_entries and checked for disable_date value with sysdate.

4741: Added condition in all the cursors selecting cycle count tasks to select
4742: only those tasks whose cycle count have not been disabled by entering
4743: an Inactive Date.
4744: Added the table mtl_cycle_count_headers in the FROM clause and joined with
4745: mtl_cycle_count_entries and checked for disable_date value with sysdate.
4746: */
4747:
4748: -- Cursor # 1 for selecting the most optimal task
4749: -- 1. sub is passed (1)

Line 4802: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

4798: , TO_NUMBER(NULL) pick_slip_number
4799: , TO_NUMBER(NULL) cartonization_id
4800: , mcce.inventory_item_id
4801: , TO_NUMBER(NULL) move_order_line_id
4802: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
4803: WHERE mcce.entry_status_code IN(1, 3)
4804: AND NVL(mcce.export_flag, 2) = 2
4805: -- bug 3972076
4806: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 4956: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

4952: , TO_NUMBER(NULL) pick_slip_number
4953: , TO_NUMBER(NULL) cartonization_id
4954: , mcce.inventory_item_id
4955: , TO_NUMBER(NULL) move_order_line_id
4956: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
4957: WHERE mcce.entry_status_code IN(1, 3)
4958: AND NVL(mcce.export_flag, 2) = 2
4959: -- bug 3972076
4960: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5112: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5108: , TO_NUMBER(NULL) pick_slip_number
5109: , TO_NUMBER(NULL) cartonization_id
5110: , mcce.inventory_item_id
5111: , TO_NUMBER(NULL) move_order_line_id
5112: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5113: WHERE mcce.entry_status_code IN(1, 3)
5114: AND NVL(mcce.export_flag, 2) = 2
5115: -- bug 3972076
5116: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5265: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5261: , TO_NUMBER(NULL) pick_slip_number
5262: , TO_NUMBER(NULL) cartonization_id
5263: , mcce.inventory_item_id
5264: , TO_NUMBER(NULL) move_order_line_id
5265: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5266: WHERE mcce.entry_status_code IN(1, 3)
5267: AND NVL(mcce.export_flag, 2) = 2
5268: -- bug 3972076
5269: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5418: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5414: , TO_NUMBER(NULL) pick_slip_number
5415: , TO_NUMBER(NULL) cartonization_id
5416: , mcce.inventory_item_id
5417: , TO_NUMBER(NULL) move_order_line_id
5418: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5419: WHERE mcce.entry_status_code IN(1, 3)
5420: AND NVL(mcce.export_flag, 2) = 2
5421: -- bug 3972076
5422: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5572: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5568: , TO_NUMBER(NULL) pick_slip_number
5569: , TO_NUMBER(NULL) cartonization_id
5570: , mcce.inventory_item_id
5571: , TO_NUMBER(NULL) move_order_line_id
5572: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5573: WHERE mcce.entry_status_code IN(1, 3)
5574: AND NVL(mcce.export_flag, 2) = 2
5575: -- bug 3972076
5576: -- AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5725: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5721: , TO_NUMBER(NULL) pick_slip_number
5722: , TO_NUMBER(NULL) cartonization_id
5723: , mcce.inventory_item_id
5724: , TO_NUMBER(NULL) move_order_line_id
5725: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5726: WHERE mcce.entry_status_code IN(1, 3)
5727: AND NVL(mcce.export_flag, 2) = 2
5728: -- bug 3972076
5729: -- AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5876: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5872: , TO_NUMBER(NULL) pick_slip_number
5873: , TO_NUMBER(NULL) cartonization_id
5874: , mcce.inventory_item_id
5875: , TO_NUMBER(NULL) move_order_line_id
5876: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5877: WHERE mcce.entry_status_code IN(1, 3)
5878: AND NVL(mcce.export_flag, 2) = 2
5879: -- bug 3972076
5880: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 6024: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

6020: , TO_NUMBER(NULL) pick_slip_number
6021: , TO_NUMBER(NULL) cartonization_id
6022: , mcce.inventory_item_id
6023: , TO_NUMBER(NULL) move_order_line_id
6024: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
6025: WHERE mcce.entry_status_code IN(1, 3)
6026: AND NVL(mcce.export_flag, 2) = 2
6027: -- bug 3972076
6028: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 6175: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

6171: , TO_NUMBER(NULL) pick_slip_number
6172: , TO_NUMBER(NULL) cartonization_id
6173: , mcce.inventory_item_id
6174: , TO_NUMBER(NULL) move_order_line_id
6175: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
6176: WHERE mcce.entry_status_code IN(1, 3)
6177: AND NVL(mcce.export_flag, 2) = 2
6178: -- bug 3972076
6179: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 6328: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

6324: , TO_NUMBER(NULL) pick_slip_number
6325: , TO_NUMBER(NULL) cartonization_id
6326: , mcce.inventory_item_id
6327: , TO_NUMBER(NULL) move_order_line_id
6328: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
6329: WHERE mcce.entry_status_code IN(1, 3)
6330: AND NVL(mcce.export_flag, 2) = 2
6331: -- bug 3972076
6332: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 6476: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

6472: , TO_NUMBER(NULL) pick_slip_number
6473: , TO_NUMBER(NULL) cartonization_id
6474: , mcce.inventory_item_id
6475: , TO_NUMBER(NULL) move_order_line_id
6476: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
6477: WHERE mcce.entry_status_code IN(1, 3)
6478: AND NVL(mcce.export_flag, 2) = 2
6479: -- bug 3972076
6480: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 6828: FROM mtl_cycle_count_entries

6824: , TO_NUMBER(NULL) pick_slip_number
6825: , TO_NUMBER(NULL) cartonization_id
6826: , inventory_item_id
6827: , TO_NUMBER(NULL) move_order_line_id
6828: FROM mtl_cycle_count_entries
6829: WHERE entry_status_code IN(1, 3)
6830: AND NVL(export_flag, 2) = 2
6831: -- bug 3972076
6832: --AND NVL(TRUNC(count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 6842: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks

6838:
6839: -- Added the previous line since the task_id in the view
6840: -- might not be unique since it is the transaction_temp_id
6841: -- if it comes from MMTT but the cycle_count_entry_id if
6842: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks
6843: l_progress := '36';
6844: EXCEPTION
6845: WHEN OTHERS THEN
6846: -- locator definition descripency

Line 6879: -- get the location from mtl_cycle_count_entries

6875: l_cur_y := 0;
6876: l_cur_z := 0;
6877: END;
6878: ELSE -- l_last_task_type <> 3 (Cyclt Count task)
6879: -- get the location from mtl_cycle_count_entries
6880: BEGIN
6881: l_progress := '39';
6882:
6883: -- use Nvl to make sure if coordinates not defined, use 0

Line 6890: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

6886: , NVL(loc.z_coordinate, 0)
6887: INTO l_cur_x
6888: , l_cur_y
6889: , l_cur_z
6890: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
6891: WHERE mcce.locator_id = loc.inventory_location_id
6892: AND mcce.organization_id = loc.organization_id
6893: AND mcce.cycle_count_entry_id = l_last_task_id;
6894:

Line 7270: FROM mtl_cycle_count_entries mcce

7266: -- Cycle counting tasks
7267: BEGIN
7268: SELECT mcce.cycle_count_entry_id
7269: INTO l_opt_task_id
7270: FROM mtl_cycle_count_entries mcce
7271: WHERE mcce.cycle_count_entry_id = l_opt_task_id
7272: FOR UPDATE NOWAIT;
7273: EXCEPTION
7274: WHEN OTHERS THEN

Line 7335: FROM mtl_cycle_count_entries mcce

7331: -- Cycle counting tasks
7332: BEGIN
7333: SELECT mcce.cycle_count_entry_id
7334: INTO l_opt_task_id
7335: FROM mtl_cycle_count_entries mcce
7336: WHERE mcce.cycle_count_entry_id = l_opt_task_id
7337: FOR UPDATE NOWAIT;
7338: EXCEPTION
7339: WHEN OTHERS THEN

Line 7453: FROM mtl_cycle_count_entries mcce, wms_ordered_tasks wot

7449: , TO_NUMBER(NULL) transaction_quantity
7450: , MIN(mcce.lot_number) lot_number
7451: , 3 wms_task_type_id
7452: , MIN(mcce.task_priority) task_priority
7453: FROM mtl_cycle_count_entries mcce, wms_ordered_tasks wot
7454: WHERE mcce.entry_status_code IN(1, 3)
7455: AND NVL(mcce.export_flag, 2) = 2
7456: -- bug 3972076
7457: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 7705: FROM mtl_cycle_count_entries

7701: To_number(NULL) pick_slip_number,
7702: To_number(NULL) cartonization_id,
7703: inventory_item_id,
7704: To_number(NULL) move_order_line_id
7705: FROM mtl_cycle_count_entries
7706: WHERE entry_status_code IN (1,3)
7707: AND NVL(export_flag, 2) = 2
7708: -- bug 3972076
7709: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')

Line 7866: FROM mtl_cycle_count_entries

7862: To_number(NULL) pick_slip_number,
7863: To_number(NULL) cartonization_id,
7864: inventory_item_id,
7865: To_number(NULL) move_order_line_id
7866: FROM mtl_cycle_count_entries
7867: WHERE entry_status_code IN (1,3)
7868: AND NVL(export_flag, 2) = 2
7869: -- bug 3972076
7870: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')

Line 8026: FROM mtl_cycle_count_entries

8022: To_number(NULL) pick_slip_number,
8023: To_number(NULL) cartonization_id,
8024: inventory_item_id,
8025: To_number(NULL) move_order_line_id
8026: FROM mtl_cycle_count_entries
8027: WHERE entry_status_code IN (1,3)
8028: AND NVL(export_flag, 2) = 2
8029: -- bug 3972076
8030: -- AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')

Line 8186: FROM mtl_cycle_count_entries

8182: To_number(NULL) pick_slip_number,
8183: To_number(NULL) cartonization_id,
8184: inventory_item_id,
8185: To_number(NULL) move_order_line_id
8186: FROM mtl_cycle_count_entries
8187: WHERE entry_status_code IN (1,3)
8188: AND NVL(export_flag, 2) = 2
8189: -- bug 3972076
8190: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')

Line 10356: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks

10352:
10353: -- Added the previous line since the task_id in the view
10354: -- might not be unique since it is the transaction_temp_id
10355: -- if it comes from MMTT but the cycle_count_entry_id if
10356: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks
10357: l_progress := '36';
10358: EXCEPTION
10359: WHEN OTHERS THEN
10360: -- locator definition descripency

Line 10391: ELSE -- l_last_task_type <> 3 (Cyclt Count task) hence get the location from mtl_cycle_count_entries

10387: l_cur_x := 0;
10388: l_cur_y := 0;
10389: l_cur_z := 0;
10390: END;
10391: ELSE -- l_last_task_type <> 3 (Cyclt Count task) hence get the location from mtl_cycle_count_entries
10392: BEGIN
10393: l_progress := '39';
10394:
10395: -- use Nvl to make sure if coordinates not defined, use 0

Line 10402: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

10398: , NVL(loc.z_coordinate, 0)
10399: INTO l_cur_x
10400: , l_cur_y
10401: , l_cur_z
10402: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
10403: WHERE mcce.locator_id = loc.inventory_location_id
10404: AND mcce.organization_id = loc.organization_id
10405: AND mcce.cycle_count_entry_id = l_last_task_id;
10406: