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_BULK_ORDER_IMPORT_PVT dependencies on OE_SYS_PARAMETERS_ALL

Line 446: oe_sys_parameters_all sys

442: , NULL request_id
443: , NULL batch_id
444: , h.org_id
445: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432
446: oe_sys_parameters_all sys
447: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
448: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
449: AND h.org_id = l.org_id
450: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313

Line 523: oe_sys_parameters_all sys

519: , NULL request_id
520: , NULL batch_id
521: , h.org_id org_id
522: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432
523: oe_sys_parameters_all sys
524: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
525: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
526: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
527: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'

Line 576: oe_sys_parameters_all sys

572: , NULL request_id
573: , NULL batch_id
574: , l_default_org_id org_id
575: FROM oe_headers_iface_all h, oe_lines_iface_all l, --bug 4685432
576: oe_sys_parameters_all sys
577: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
578: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
579: AND nvl(sys.org_id,l_default_org_id) = l_default_org_id --bug 4685432, 5209313
580: AND sys.org_id(+) = h.org_id

Line 793: oe_sys_parameters_all sys

789: FROM(
790: SELECT /* MOAC_SQL_CHANGE */
791: h.orig_sys_document_ref orig_sys_document_ref
792: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
793: oe_sys_parameters_all sys
794: WHERE request_id IS NULL
795: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
796: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'
797: AND nvl(sys.parameter_value,'N') = 'N'

Line 851: oe_sys_parameters_all sys

847: AND operation_code <> 'BOOK_ORDER')
848: UNION
849: SELECT h.orig_sys_document_ref orig_sys_document_ref
850: FROM oe_headers_iface_all h, oe_order_sources os, --bug 4685432
851: oe_sys_parameters_all sys
852: WHERE request_id IS NULL
853: AND nvl(sys.org_id,l_default_org_id) = l_default_org_id --bug 4685432, 5209313
854: AND sys.org_id(+) = h.org_id
855: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'

Line 900: oe_sys_parameters_all sys

896: oe_debug_pub.add('p_process_recs_with_no_org =N',1);
897: SELECT /* MOAC_SQL_CHANGE */ count(*)
898: INTO l_row_count
899: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
900: oe_sys_parameters_all sys
901: WHERE request_id IS NULL
902: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
903: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'
904: AND nvl(sys.parameter_value,'N') = 'N'