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.OE_ORDER_IMPORT_MAIN_PVT dependencies on OE_HEADERS_IFACE_ALL

Line 37: tabname => 'OE_HEADERS_IFACE_ALL');

33: oe_debug_pub.add( 'BEFORE CALLING PERF STATISTICS API' ) ;
34: END IF;
35:
36: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
37: tabname => 'OE_HEADERS_IFACE_ALL');
38: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
39: tabname => 'OE_LINES_IFACE_ALL');
40: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
41: tabname => 'OE_ACTIONS_IFACE_ALL');

Line 192: FROM oe_headers_iface_all

188: , sold_to_org
189: , change_sequence
190: , nvl(closed_flag, 'N')
191: ,org_id
192: FROM oe_headers_iface_all
193: WHERE request_id = l_request_id
194: AND decode(p_perf_param, 'Y',
195: nvl(error_flag,'N'), ' ')
196: = decode(p_perf_param, 'Y',

Line 411: FROM oe_headers_iface_all

407: -----------------------------------------------------------
408: */
409: /* oe_debug_pub.add('No of orders in inf table');
410: SELECT COUNT(*) INTO l_ord_count
411: FROM oe_headers_iface_all
412: WHERE order_source_id = 1084
413: AND ( nvl(NULL,' ') = ' ' OR
414: (nvl(NULL,' ') <> ' ' AND
415: nvl(NULL,' ') = nvl(orig_sys_document_ref,' ')))

Line 457: UPDATE oe_headers_iface_all

453: (p_operating_unit IS NULL AND
454: p_default_org_id IS NOT NULL)
455: THEN
456:
457: UPDATE oe_headers_iface_all
458: SET request_id = l_request_id,
459: org_id = p_default_org_id
460: WHERE order_source_id = l_order_source_id
461: AND ( nvl(l_orig_sys_document_ref,' ') = ' ' OR

Line 493: FROM oe_headers_iface_all -- MOAC

489: COMMIT;
490:
491: SELECT COUNT(*)
492: INTO l_row_count
493: FROM oe_headers_iface_all -- MOAC
494: WHERE request_id = l_request_id;
495: IF l_debug_level > 0 THEN
496: oe_debug_pub.add( 'ROW COUNT = '||L_ROW_COUNT ) ;
497: END IF;

Line 567: UPDATE oe_headers_iface_all

563: END IF;
564:
565: IF (p_perf_param = 'Y') THEN
566: -- only update one record
567: UPDATE oe_headers_iface_all
568: SET request_id = new_request_id
569: WHERE request_id = l_request_id
570: AND ROWNUM =1;
571: ELSE

Line 573: UPDATE oe_headers_iface_all

569: WHERE request_id = l_request_id
570: AND ROWNUM =1;
571: ELSE
572: -- update batchsize records
573: UPDATE oe_headers_iface_all
574: SET request_id = new_request_id
575: WHERE request_id = l_request_id
576: AND ROWNUM <= batch_size;
577: END IF;

Line 627: FROM oe_headers_iface_all

623: SET request_id = l_request_id
624: WHERE (order_source_id, orig_sys_document_ref, nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
625: ( SELECT order_source_id, orig_sys_document_ref,
626: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
627: FROM oe_headers_iface_all
628: WHERE request_id = l_request_id);
629: /*AND decode(p_perf_param, 'Y',
630: nvl(error_flag,'N'), ' ')
631: = decode(p_perf_param, 'Y',

Line 646: FROM oe_headers_iface_all

642: WHERE (order_source_id, orig_sys_document_ref,
643: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
644: ( SELECT order_source_id, orig_sys_document_ref,
645: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
646: FROM oe_headers_iface_all
647: WHERE request_id = l_request_id) ;
648: /*AND decode(p_perf_param, 'Y',
649: nvl(error_flag,'N'), ' ')
650: = decode(p_perf_param, 'Y',

Line 662: FROM oe_headers_iface_all

658: WHERE (order_source_id, orig_sys_document_ref,
659: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
660: ( SELECT order_source_id, orig_sys_document_ref,
661: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
662: FROM oe_headers_iface_all
663: WHERE request_id = l_request_id) ;
664: /* AND decode(p_perf_param, 'Y',
665: nvl(error_flag,'N'), ' ')
666: = decode(p_perf_param, 'Y',

Line 683: FROM oe_headers_iface_all

679: WHERE (order_source_id, orig_sys_document_ref,
680: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
681: ( SELECT order_source_id, orig_sys_document_ref,
682: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
683: FROM oe_headers_iface_all
684: WHERE request_id = l_request_id) ;
685: /* AND decode(p_perf_param, 'Y',
686: nvl(error_flag,'N'), ' ')
687: = decode(p_perf_param, 'Y',

Line 699: FROM oe_headers_iface_all

695: WHERE (order_source_id, orig_sys_document_ref,
696: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
697: ( SELECT order_source_id, orig_sys_document_ref,
698: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
699: FROM oe_headers_iface_all
700: WHERE request_id = l_request_id) ;
701: /*AND decode(p_perf_param, 'Y',
702: nvl(error_flag,'N'), ' ')
703: = decode(p_perf_param, 'Y',

Line 714: FROM oe_headers_iface_all

710: WHERE (order_source_id, orig_sys_document_ref,
711: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
712: ( SELECT order_source_id, orig_sys_document_ref,
713: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
714: FROM oe_headers_iface_all
715: WHERE request_id = l_request_id) ;
716: /*AND decode(p_perf_param, 'Y',
717: nvl(error_flag,'N'), ' ')
718: = decode(p_perf_param, 'Y',

Line 729: FROM oe_headers_iface_all

725: WHERE (order_source_id, orig_sys_document_ref,
726: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
727: ( SELECT order_source_id, orig_sys_document_ref,
728: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
729: FROM oe_headers_iface_all
730: WHERE request_id = l_request_id) ;
731: /* AND decode(p_perf_param, 'Y',
732: nvl(error_flag,'N'), ' ')
733: = decode(p_perf_param, 'Y',

Line 744: FROM oe_headers_iface_all

740: WHERE (order_source_id, orig_sys_document_ref,
741: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
742: ( SELECT order_source_id, orig_sys_document_ref,
743: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
744: FROM oe_headers_iface_all
745: WHERE request_id = l_request_id) ;
746: /* AND decode(p_perf_param, 'Y',
747: nvl(error_flag,'N'), ' ')
748: = decode(p_perf_param, 'Y',

Line 1057: from oe_headers_iface_all --MOAC

1053: loop
1054:
1055: select rowidtochar(rowid)
1056: into l_rowid
1057: from oe_headers_iface_all --MOAC
1058: where request_id = l_pnt_request_id
1059: and rownum = 1;
1060:
1061: UPDATE oe_headers_iface_all --MOAC

Line 1061: UPDATE oe_headers_iface_all --MOAC

1057: from oe_headers_iface_all --MOAC
1058: where request_id = l_pnt_request_id
1059: and rownum = 1;
1060:
1061: UPDATE oe_headers_iface_all --MOAC
1062: SET request_id = l_request_id
1063: WHERE request_id = l_pnt_request_id
1064: AND nvl(error_flag,'N') = 'N'
1065: AND rowidtochar(rowid) = l_rowid

Line 1241: FROM oe_headers_iface_all

1237:
1238:
1239: SELECT closed_flag
1240: INTO l_closed_flag
1241: FROM oe_headers_iface_all
1242: WHERE orig_sys_document_ref = p_orig_sys_document_ref
1243: AND order_source_id = p_order_source_id
1244: AND nvl(sold_to_org_id, -999) = nvl(p_sold_to_org_id, -999)
1245: AND nvl(sold_to_org, ' ') = nvl(p_sold_to_org, ' ')