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 273: mtl_cycle_count_entries and checked for disable_date value with sysdate.

269: Added condition in all the cursors selecting cycle count tasks to select
270: only those tasks whose cycle count have not been disabled by entering
271: an Inactive Date.
272: Added the table mtl_cycle_count_headers in the FROM clause and joined with
273: mtl_cycle_count_entries and checked for disable_date value with sysdate.
274: */
275:
276: -- Cursor #1 for selecting the most optimal task
277: -- 1. Sub is passed (1)

Line 344: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

340: 4 transaction_type_id,
341: 4 transaction_action_id,
342: mcce.cycle_count_header_id transaction_source_id,
343: 9 transaction_source_type_id
344: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
345: WHERE mcce.entry_status_code IN(1, 3)
346: AND NVL(mcce.export_flag, 2) = 2
347: -- bug 3972076
348: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 464: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

460: 4 transaction_type_id,
461: 4 transaction_action_id,
462: mcce.cycle_count_header_id transaction_source_id,
463: 9 transaction_source_type_id
464: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
465: WHERE mcce.entry_status_code IN(1, 3)
466: AND NVL(mcce.export_flag, 2) = 2
467: -- bug 3972076
468: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 982: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

978: 4 transaction_type_id,
979: 4 transaction_action_id,
980: mcce.cycle_count_header_id transaction_source_id,
981: 9 transaction_source_type_id
982: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
983: WHERE mcce.entry_status_code IN(1, 3)
984: AND NVL(mcce.export_flag, 2) = 2
985: -- bug 3972076
986: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1060: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1056: 4 transaction_type_id,
1057: 4 transaction_action_id,
1058: mcce.cycle_count_header_id transaction_source_id,
1059: 9 transaction_source_type_id
1060: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1061: WHERE mcce.entry_status_code IN(1, 3)
1062: AND NVL(mcce.export_flag, 2) = 2
1063: -- bug 3972076
1064: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1248: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1244: 4 transaction_type_id,
1245: 4 transaction_action_id,
1246: mcce.cycle_count_header_id transaction_source_id,
1247: 9 transaction_source_type_id
1248: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1249: WHERE mcce.entry_status_code IN(1, 3)
1250: AND NVL(mcce.export_flag, 2) = 2
1251: -- bug 3972076
1252: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1371: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1367: 4 transaction_type_id,
1368: 4 transaction_action_id,
1369: mcce.cycle_count_header_id transaction_source_id,
1370: 9 transaction_source_type_id
1371: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1372: WHERE mcce.entry_status_code IN(1, 3)
1373: AND NVL(mcce.export_flag, 2) = 2
1374: -- bug 3972076
1375: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1886: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1882: 4 transaction_type_id,
1883: 4 transaction_action_id,
1884: mcce.cycle_count_header_id transaction_source_id,
1885: 9 transaction_source_type_id
1886: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1887: WHERE mcce.entry_status_code IN(1, 3)
1888: AND NVL(mcce.export_flag, 2) = 2
1889: -- bug 3972076
1890: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 1956: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

1952: 4 transaction_type_id,
1953: 4 transaction_action_id,
1954: mcce.cycle_count_header_id transaction_source_id,
1955: 9 transaction_source_type_id
1956: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
1957: WHERE mcce.entry_status_code IN(1, 3)
1958: AND NVL(mcce.export_flag, 2) = 2
1959: -- bug 3972076
1960: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 2174: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

2170: 4 transaction_type_id,
2171: 4 transaction_action_id,
2172: mcce.cycle_count_header_id transaction_source_id,
2173: 9 transaction_source_type_id
2174: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
2175: WHERE mcce.entry_status_code IN(1, 3)
2176: AND NVL(mcce.export_flag, 2) = 2
2177: -- bug 3972076
2178: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 2327: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

2323: 4 transaction_action_id,
2324: mcce.cycle_count_header_id transaction_source_id,
2325: 9 transaction_source_type_id,
2326: To_number(NULL) operation_plan_id
2327: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
2328: WHERE mcce.entry_status_code IN(1, 3)
2329: AND NVL(mcce.export_flag, 2) = 2
2330: -- bug 3972076
2331: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 2929: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

2925: 4 transaction_type_id,
2926: 4 transaction_action_id,
2927: mcce.cycle_count_header_id transaction_source_id,
2928: 9 transaction_source_type_id
2929: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
2930: WHERE mcce.entry_status_code IN(1, 3)
2931: AND NVL(mcce.export_flag, 2) = 2
2932: -- bug 3972076
2933: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 3019: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

3015: 4 transaction_action_id,
3016: mcce.cycle_count_header_id transaction_source_id,
3017: 9 transaction_source_type_id,
3018: To_number(NULL) operation_plan_id
3019: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
3020: WHERE mcce.entry_status_code IN(1, 3)
3021: AND NVL(mcce.export_flag, 2) = 2
3022: -- bug 3972076
3023: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 3155: FROM mtl_cycle_count_entries

3151: FOR UPDATE nowait;
3152:
3153: CURSOR c_cycle_count_lock_check(v_cycle_count_entry_id NUMBER) IS
3154: SELECT cycle_count_entry_id
3155: FROM mtl_cycle_count_entries
3156: WHERE cycle_count_entry_id = v_cycle_count_entry_id
3157: FOR UPDATE nowait;
3158:
3159: CURSOR c_task_filter(v_filter_name VARCHAR2) IS

Line 3408: FROM mtl_cycle_count_entries

3404: TO_NUMBER(NULL) pick_slip_number,
3405: TO_NUMBER(NULL) cartonization_id,
3406: inventory_item_id,
3407: TO_NUMBER(NULL) move_order_line_id
3408: FROM mtl_cycle_count_entries
3409: WHERE entry_status_code IN(1, 3)
3410: AND NVL(export_flag, 2) = 2
3411: -- bug 3972076
3412: --AND NVL(TRUNC(count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

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

3418:
3419: -- Added the previous line since the task_id in the view
3420: -- might not be unique since it is the transaction_temp_id
3421: -- if it comes from MMTT but the cycle_count_entry_id if
3422: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks
3423: l_progress := '36';
3424: EXCEPTION
3425: WHEN OTHERS THEN
3426: -- locator definition descripency

Line 3459: -- get the location from mtl_cycle_count_entries

3455: l_cur_y := 0;
3456: l_cur_z := 0;
3457: END;
3458: ELSE -- l_last_task_type <> 3 (Cyclt Count task)
3459: -- get the location from mtl_cycle_count_entries
3460: BEGIN
3461: l_progress := '39';
3462:
3463: -- use Nvl to make sure if coordinates not defined, use 0

Line 3470: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

3466: , NVL(loc.z_coordinate, 0)
3467: INTO l_cur_x
3468: , l_cur_y
3469: , l_cur_z
3470: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
3471: WHERE mcce.locator_id = loc.inventory_location_id
3472: AND mcce.organization_id = loc.organization_id
3473: AND mcce.cycle_count_entry_id = l_last_task_id;
3474:

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

4402: Added condition in all the cursors selecting cycle count tasks to select
4403: only those tasks whose cycle count have not been disabled by entering
4404: an Inactive Date.
4405: Added the table mtl_cycle_count_headers in the FROM clause and joined with
4406: mtl_cycle_count_entries and checked for disable_date value with sysdate.
4407: */
4408:
4409: -- Cursor # 1 for selecting the most optimal task
4410: -- 1. sub is passed (1)

Line 4463: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

4459: , TO_NUMBER(NULL) pick_slip_number
4460: , TO_NUMBER(NULL) cartonization_id
4461: , mcce.inventory_item_id
4462: , TO_NUMBER(NULL) move_order_line_id
4463: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
4464: WHERE mcce.entry_status_code IN(1, 3)
4465: AND NVL(mcce.export_flag, 2) = 2
4466: -- bug 3972076
4467: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 4617: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

4613: , TO_NUMBER(NULL) pick_slip_number
4614: , TO_NUMBER(NULL) cartonization_id
4615: , mcce.inventory_item_id
4616: , TO_NUMBER(NULL) move_order_line_id
4617: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
4618: WHERE mcce.entry_status_code IN(1, 3)
4619: AND NVL(mcce.export_flag, 2) = 2
4620: -- bug 3972076
4621: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 4773: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

4769: , TO_NUMBER(NULL) pick_slip_number
4770: , TO_NUMBER(NULL) cartonization_id
4771: , mcce.inventory_item_id
4772: , TO_NUMBER(NULL) move_order_line_id
4773: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
4774: WHERE mcce.entry_status_code IN(1, 3)
4775: AND NVL(mcce.export_flag, 2) = 2
4776: -- bug 3972076
4777: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 4926: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

4922: , TO_NUMBER(NULL) pick_slip_number
4923: , TO_NUMBER(NULL) cartonization_id
4924: , mcce.inventory_item_id
4925: , TO_NUMBER(NULL) move_order_line_id
4926: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
4927: WHERE mcce.entry_status_code IN(1, 3)
4928: AND NVL(mcce.export_flag, 2) = 2
4929: -- bug 3972076
4930: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5079: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5075: , TO_NUMBER(NULL) pick_slip_number
5076: , TO_NUMBER(NULL) cartonization_id
5077: , mcce.inventory_item_id
5078: , TO_NUMBER(NULL) move_order_line_id
5079: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5080: WHERE mcce.entry_status_code IN(1, 3)
5081: AND NVL(mcce.export_flag, 2) = 2
5082: -- bug 3972076
5083: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5233: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5229: , TO_NUMBER(NULL) pick_slip_number
5230: , TO_NUMBER(NULL) cartonization_id
5231: , mcce.inventory_item_id
5232: , TO_NUMBER(NULL) move_order_line_id
5233: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5234: WHERE mcce.entry_status_code IN(1, 3)
5235: AND NVL(mcce.export_flag, 2) = 2
5236: -- bug 3972076
5237: -- AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5386: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5382: , TO_NUMBER(NULL) pick_slip_number
5383: , TO_NUMBER(NULL) cartonization_id
5384: , mcce.inventory_item_id
5385: , TO_NUMBER(NULL) move_order_line_id
5386: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5387: WHERE mcce.entry_status_code IN(1, 3)
5388: AND NVL(mcce.export_flag, 2) = 2
5389: -- bug 3972076
5390: -- AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5537: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5533: , TO_NUMBER(NULL) pick_slip_number
5534: , TO_NUMBER(NULL) cartonization_id
5535: , mcce.inventory_item_id
5536: , TO_NUMBER(NULL) move_order_line_id
5537: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5538: WHERE mcce.entry_status_code IN(1, 3)
5539: AND NVL(mcce.export_flag, 2) = 2
5540: -- bug 3972076
5541: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5685: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5681: , TO_NUMBER(NULL) pick_slip_number
5682: , TO_NUMBER(NULL) cartonization_id
5683: , mcce.inventory_item_id
5684: , TO_NUMBER(NULL) move_order_line_id
5685: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5686: WHERE mcce.entry_status_code IN(1, 3)
5687: AND NVL(mcce.export_flag, 2) = 2
5688: -- bug 3972076
5689: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5836: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5832: , TO_NUMBER(NULL) pick_slip_number
5833: , TO_NUMBER(NULL) cartonization_id
5834: , mcce.inventory_item_id
5835: , TO_NUMBER(NULL) move_order_line_id
5836: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5837: WHERE mcce.entry_status_code IN(1, 3)
5838: AND NVL(mcce.export_flag, 2) = 2
5839: -- bug 3972076
5840: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 5989: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

5985: , TO_NUMBER(NULL) pick_slip_number
5986: , TO_NUMBER(NULL) cartonization_id
5987: , mcce.inventory_item_id
5988: , TO_NUMBER(NULL) move_order_line_id
5989: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
5990: WHERE mcce.entry_status_code IN(1, 3)
5991: AND NVL(mcce.export_flag, 2) = 2
5992: -- bug 3972076
5993: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 6137: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

6133: , TO_NUMBER(NULL) pick_slip_number
6134: , TO_NUMBER(NULL) cartonization_id
6135: , mcce.inventory_item_id
6136: , TO_NUMBER(NULL) move_order_line_id
6137: FROM mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
6138: WHERE mcce.entry_status_code IN(1, 3)
6139: AND NVL(mcce.export_flag, 2) = 2
6140: -- bug 3972076
6141: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 6489: FROM mtl_cycle_count_entries

6485: , TO_NUMBER(NULL) pick_slip_number
6486: , TO_NUMBER(NULL) cartonization_id
6487: , inventory_item_id
6488: , TO_NUMBER(NULL) move_order_line_id
6489: FROM mtl_cycle_count_entries
6490: WHERE entry_status_code IN(1, 3)
6491: AND NVL(export_flag, 2) = 2
6492: -- bug 3972076
6493: --AND NVL(TRUNC(count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

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

6499:
6500: -- Added the previous line since the task_id in the view
6501: -- might not be unique since it is the transaction_temp_id
6502: -- if it comes from MMTT but the cycle_count_entry_id if
6503: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks
6504: l_progress := '36';
6505: EXCEPTION
6506: WHEN OTHERS THEN
6507: -- locator definition descripency

Line 6540: -- get the location from mtl_cycle_count_entries

6536: l_cur_y := 0;
6537: l_cur_z := 0;
6538: END;
6539: ELSE -- l_last_task_type <> 3 (Cyclt Count task)
6540: -- get the location from mtl_cycle_count_entries
6541: BEGIN
6542: l_progress := '39';
6543:
6544: -- use Nvl to make sure if coordinates not defined, use 0

Line 6551: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

6547: , NVL(loc.z_coordinate, 0)
6548: INTO l_cur_x
6549: , l_cur_y
6550: , l_cur_z
6551: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
6552: WHERE mcce.locator_id = loc.inventory_location_id
6553: AND mcce.organization_id = loc.organization_id
6554: AND mcce.cycle_count_entry_id = l_last_task_id;
6555:

Line 6931: FROM mtl_cycle_count_entries mcce

6927: -- Cycle counting tasks
6928: BEGIN
6929: SELECT mcce.cycle_count_entry_id
6930: INTO l_opt_task_id
6931: FROM mtl_cycle_count_entries mcce
6932: WHERE mcce.cycle_count_entry_id = l_opt_task_id
6933: FOR UPDATE NOWAIT;
6934: EXCEPTION
6935: WHEN OTHERS THEN

Line 6996: FROM mtl_cycle_count_entries mcce

6992: -- Cycle counting tasks
6993: BEGIN
6994: SELECT mcce.cycle_count_entry_id
6995: INTO l_opt_task_id
6996: FROM mtl_cycle_count_entries mcce
6997: WHERE mcce.cycle_count_entry_id = l_opt_task_id
6998: FOR UPDATE NOWAIT;
6999: EXCEPTION
7000: WHEN OTHERS THEN

Line 7114: FROM mtl_cycle_count_entries mcce, wms_ordered_tasks wot

7110: , TO_NUMBER(NULL) transaction_quantity
7111: , MIN(mcce.lot_number) lot_number
7112: , 3 wms_task_type_id
7113: , MIN(mcce.task_priority) task_priority
7114: FROM mtl_cycle_count_entries mcce, wms_ordered_tasks wot
7115: WHERE mcce.entry_status_code IN(1, 3)
7116: AND NVL(mcce.export_flag, 2) = 2
7117: -- bug 3972076
7118: --AND NVL(TRUNC(mcce.count_due_date, 'DD'), TRUNC(SYSDATE, 'DD')) >= TRUNC(SYSDATE, 'DD')

Line 7366: FROM mtl_cycle_count_entries

7362: To_number(NULL) pick_slip_number,
7363: To_number(NULL) cartonization_id,
7364: inventory_item_id,
7365: To_number(NULL) move_order_line_id
7366: FROM mtl_cycle_count_entries
7367: WHERE entry_status_code IN (1,3)
7368: AND NVL(export_flag, 2) = 2
7369: -- bug 3972076
7370: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')

Line 7527: FROM mtl_cycle_count_entries

7523: To_number(NULL) pick_slip_number,
7524: To_number(NULL) cartonization_id,
7525: inventory_item_id,
7526: To_number(NULL) move_order_line_id
7527: FROM mtl_cycle_count_entries
7528: WHERE entry_status_code IN (1,3)
7529: AND NVL(export_flag, 2) = 2
7530: -- bug 3972076
7531: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')

Line 7687: FROM mtl_cycle_count_entries

7683: To_number(NULL) pick_slip_number,
7684: To_number(NULL) cartonization_id,
7685: inventory_item_id,
7686: To_number(NULL) move_order_line_id
7687: FROM mtl_cycle_count_entries
7688: WHERE entry_status_code IN (1,3)
7689: AND NVL(export_flag, 2) = 2
7690: -- bug 3972076
7691: -- AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')

Line 7847: FROM mtl_cycle_count_entries

7843: To_number(NULL) pick_slip_number,
7844: To_number(NULL) cartonization_id,
7845: inventory_item_id,
7846: To_number(NULL) move_order_line_id
7847: FROM mtl_cycle_count_entries
7848: WHERE entry_status_code IN (1,3)
7849: AND NVL(export_flag, 2) = 2
7850: -- bug 3972076
7851: --AND NVL(Trunc(count_due_date, 'DD'), Trunc(Sysdate, 'DD')) >= Trunc(Sysdate, 'DD')

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

10013:
10014: -- Added the previous line since the task_id in the view
10015: -- might not be unique since it is the transaction_temp_id
10016: -- if it comes from MMTT but the cycle_count_entry_id if
10017: -- it comes from MTL_CYCLE_COUNT_ENTRIES for cycle counting tasks
10018: l_progress := '36';
10019: EXCEPTION
10020: WHEN OTHERS THEN
10021: -- locator definition descripency

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

10048: l_cur_x := 0;
10049: l_cur_y := 0;
10050: l_cur_z := 0;
10051: END;
10052: ELSE -- l_last_task_type <> 3 (Cyclt Count task) hence get the location from mtl_cycle_count_entries
10053: BEGIN
10054: l_progress := '39';
10055:
10056: -- use Nvl to make sure if coordinates not defined, use 0

Line 10063: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce

10059: , NVL(loc.z_coordinate, 0)
10060: INTO l_cur_x
10061: , l_cur_y
10062: , l_cur_z
10063: FROM mtl_item_locations loc, mtl_cycle_count_entries mcce
10064: WHERE mcce.locator_id = loc.inventory_location_id
10065: AND mcce.organization_id = loc.organization_id
10066: AND mcce.cycle_count_entry_id = l_last_task_id;
10067: