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

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

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

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

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