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_VALUE_TO_ID dependencies on DUAL

Line 845: FROM DUAL

841: (SELECT Get_Contact_ID(c.SHIP_TO_CONTACT,c.SHIP_TO_ORG_ID),
842: DECODE(Get_Contact_ID(c.SHIP_TO_CONTACT,c.SHIP_TO_ORG_ID),NULL,'Y',NULL),
843: DECODE(Get_Contact_ID(c.SHIP_TO_CONTACT,c.SHIP_TO_ORG_ID),NULL,
844: c.ATTRIBUTE_STATUS||'017',c.ATTRIBUTE_STATUS)
845: FROM DUAL
846: )
847: WHERE c.batch_id = p_batch_id
848: AND c.SHIP_TO_CONTACT_ID IS NULL
849: AND c.SHIP_TO_CONTACT IS NOT NULL;

Line 860: FROM DUAL

856: (SELECT Get_Contact_ID(c.INVOICE_TO_CONTACT,c.INVOICE_TO_ORG_ID),
857: DECODE(Get_Contact_ID(c.INVOICE_TO_CONTACT,c.INVOICE_TO_ORG_ID),NULL,'Y',NULL),
858: DECODE(Get_Contact_ID(c.INVOICE_TO_CONTACT,c.INVOICE_TO_ORG_ID),NULL,
859: c.ATTRIBUTE_STATUS||'018',c.ATTRIBUTE_STATUS)
860: FROM DUAL
861: )
862: WHERE c.batch_id = p_batch_id
863: AND c.INVOICE_TO_CONTACT_ID IS NULL
864: AND c.INVOICE_TO_CONTACT IS NOT NULL;

Line 875: FROM DUAL

871: (SELECT Get_Contact_ID(c.DELIVER_TO_CONTACT,c.DELIVER_TO_ORG_ID),
872: DECODE(Get_Contact_ID(c.DELIVER_TO_CONTACT,c.DELIVER_TO_ORG_ID),NULL,'Y',NULL),
873: DECODE(Get_Contact_ID(c.DELIVER_TO_CONTACT,c.DELIVER_TO_ORG_ID),NULL,
874: c.ATTRIBUTE_STATUS||'019',c.ATTRIBUTE_STATUS)
875: FROM DUAL
876: )
877: WHERE c.batch_id = p_batch_id
878: AND c.DELIVER_TO_CONTACT_ID IS NULL
879: AND c.DELIVER_TO_CONTACT IS NOT NULL;

Line 1040: FROM DUAL)

1036: c.end_customer_state,
1037: c.end_customer_postal_code,
1038: c.end_customer_country,
1039: NULL),NULL,c.ATTRIBUTE_STATUS||'027',c.ATTRIBUTE_STATUS)
1040: FROM DUAL)
1041: WHERE c.batch_id=p_batch_id
1042: AND c.END_CUSTOMER_SITE_USE_ID IS NULL AND c.END_CUSTOMER_ID IS NOT NULL
1043: AND (c.END_CUSTOMER_ADDRESS1 IS NOT NULL
1044: OR c.END_CUSTOMER_ADDRESS2 IS NOT NULL

Line 1054: FROM DUAL) WHERE c.batch_id = p_batch_id and c.END_CUSTOMER_CONTACT_ID IS NULL AND c.END_CUSTOMER_CONTACT IS NOT NULL;

1050: SET (END_CUSTOMER_CONTACT_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1051: (SELECT Get_End_customer_Contact_ID(c.END_CUSTOMER_CONTACT,c.END_CUSTOMER_ID),
1052: DECODE(Get_End_customer_Contact_ID(c.END_CUSTOMER_CONTACT,c.END_CUSTOMER_ID),NULL,'Y',NULL),
1053: DECODE(Get_End_customer_Contact_ID(c.END_CUSTOMER_CONTACT,c.END_CUSTOMER_ID),NULL,c.ATTRIBUTE_STATUS||'026',c.ATTRIBUTE_STATUS)
1054: FROM DUAL) WHERE c.batch_id = p_batch_id and c.END_CUSTOMER_CONTACT_ID IS NULL AND c.END_CUSTOMER_CONTACT IS NOT NULL;
1055:
1056: --Bug 5054618}
1057:
1058: UPDATE OE_HEADERS_IFACE_ALL c

Line 1633: FROM DUAL

1629: (SELECT Get_Contact_ID(c.SHIP_TO_CONTACT,c.SHIP_TO_ORG_ID),
1630: DECODE(Get_Contact_ID(c.SHIP_TO_CONTACT,c.SHIP_TO_ORG_ID),NULL,'Y',NULL),
1631: DECODE(Get_Contact_ID(c.SHIP_TO_CONTACT,c.SHIP_TO_ORG_ID),NULL,
1632: c.ATTRIBUTE_STATUS||'017',c.ATTRIBUTE_STATUS)
1633: FROM DUAL
1634: )
1635: WHERE (order_source_id, orig_sys_document_ref) IN
1636: ( SELECT order_source_id, orig_sys_document_ref
1637: FROM OE_HEADERS_IFACE_ALL

Line 1651: FROM DUAL

1647: (SELECT Get_Contact_ID(c.INVOICE_TO_CONTACT,c.INVOICE_TO_ORG_ID),
1648: DECODE(Get_Contact_ID(c.INVOICE_TO_CONTACT,c.INVOICE_TO_ORG_ID),NULL,'Y',NULL),
1649: DECODE(Get_Contact_ID(c.INVOICE_TO_CONTACT,c.INVOICE_TO_ORG_ID),NULL,
1650: c.ATTRIBUTE_STATUS||'018',c.ATTRIBUTE_STATUS)
1651: FROM DUAL
1652: )
1653: WHERE (order_source_id, orig_sys_document_ref) IN
1654: ( SELECT order_source_id, orig_sys_document_ref
1655: FROM OE_HEADERS_IFACE_ALL

Line 1669: FROM DUAL

1665: (SELECT Get_Contact_ID(c.DELIVER_TO_CONTACT,c.DELIVER_TO_ORG_ID),
1666: DECODE(Get_Contact_ID(c.DELIVER_TO_CONTACT,c.DELIVER_TO_ORG_ID),NULL,'Y',NULL),
1667: DECODE(Get_Contact_ID(c.DELIVER_TO_CONTACT,c.DELIVER_TO_ORG_ID),NULL,
1668: c.ATTRIBUTE_STATUS||'019',c.ATTRIBUTE_STATUS)
1669: FROM DUAL
1670: )
1671: WHERE (order_source_id, orig_sys_document_ref) IN
1672: ( SELECT order_source_id, orig_sys_document_ref
1673: FROM OE_HEADERS_IFACE_ALL

Line 1814: FROM DUAL)

1810: c.END_CUSTOMER_ID),NULL,'Y',NULL),
1811: DECODE(Get_End_customer_Contact_ID(c.END_CUSTOMER_CONTACT,
1812: c.END_CUSTOMER_ID),NULL,
1813: c.ATTRIBUTE_STATUS||'026',c.ATTRIBUTE_STATUS)
1814: FROM DUAL)
1815: WHERE (order_source_id, orig_sys_document_ref) IN
1816: ( SELECT order_source_id, orig_sys_document_ref
1817: FROM OE_HEADERS_IFACE_ALL
1818: WHERE batch_id = p_batch_id)

Line 1850: FROM DUAL)

1846: c.end_customer_postal_code,
1847: c.end_customer_country,
1848: NULL),
1849: NULL,c.ATTRIBUTE_STATUS||'027',c.ATTRIBUTE_STATUS)
1850: FROM DUAL)
1851: WHERE (order_source_id, orig_sys_document_ref) IN
1852: ( SELECT order_source_id, orig_sys_document_ref
1853: FROM OE_HEADERS_IFACE_ALL
1854: WHERE batch_id = p_batch_id)