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_HEADERS

Line 308: Added the table mtl_cycle_count_headers in the FROM clause and joined with

304: /* Bug 3808770
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

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 4744: Added the table mtl_cycle_count_headers in the FROM clause and joined with

4740: /* Bug 3856227
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

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')