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 OE_LINES_IFACE_ALL

Line 1190: UPDATE OE_LINES_IFACE_ALL c

1186: BEGIN
1187:
1188: -- LINE_TYPE
1189:
1190: UPDATE OE_LINES_IFACE_ALL c
1191: SET (LINE_TYPE_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1192: (SELECT b.transaction_type_id,
1193: DECODE(b.transaction_type_id,NULL,'Y',NULL),
1194: DECODE(b.transaction_type_id,NULL,

Line 1196: FROM OE_TRANSACTION_TYPES_TL b, OE_LINES_IFACE_ALL d

1192: (SELECT b.transaction_type_id,
1193: DECODE(b.transaction_type_id,NULL,'Y',NULL),
1194: DECODE(b.transaction_type_id,NULL,
1195: c.ATTRIBUTE_STATUS||'020',c.ATTRIBUTE_STATUS)
1196: FROM OE_TRANSACTION_TYPES_TL b, OE_LINES_IFACE_ALL d
1197: WHERE d.LINE_TYPE = b.name(+)
1198: AND NVL(b.LANGUAGE,USERENV('LANG')) = USERENV('LANG')
1199: AND d.rowid = c.rowid
1200: )

Line 1210: UPDATE OE_LINES_IFACE_ALL c

1206: AND c.LINE_TYPE IS NOT NULL;
1207:
1208: -- PRICE_LIST
1209:
1210: UPDATE OE_LINES_IFACE_ALL c
1211: SET (price_list_id,ERROR_FLAG,ATTRIBUTE_STATUS)=
1212: (SELECT b.LIST_HEADER_ID,
1213: DECODE(b.LIST_HEADER_ID,NULL,'Y',NULL),
1214: DECODE(b.LIST_HEADER_ID,NULL,

Line 1216: FROM qp_list_headers_vl b, OE_LINES_IFACE_ALL d

1212: (SELECT b.LIST_HEADER_ID,
1213: DECODE(b.LIST_HEADER_ID,NULL,'Y',NULL),
1214: DECODE(b.LIST_HEADER_ID,NULL,
1215: c.ATTRIBUTE_STATUS||'003',c.ATTRIBUTE_STATUS)
1216: FROM qp_list_headers_vl b, OE_LINES_IFACE_ALL d
1217: WHERE d.price_list = b.name(+)
1218: AND NVL(b.list_type_code,'PRL') IN ('PRL', 'AGR')
1219: AND nvl(b.active_flag,'Y') = 'Y'
1220: AND d.rowid = c.rowid

Line 1232: UPDATE OE_LINES_IFACE_ALL c

1228:
1229:
1230: -- SALESREP
1231:
1232: UPDATE OE_LINES_IFACE_ALL c
1233: SET ( SALESREP_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1234: (SELECT /*+ PUSH_PRED(b) */ b.SALESREP_ID,
1235: DECODE(b.SALESREP_ID,NULL,'Y',NULL),
1236: DECODE(b.SALESREP_ID,NULL,

Line 1238: FROM RA_SALESREPS b, OE_LINES_IFACE_ALL d

1234: (SELECT /*+ PUSH_PRED(b) */ b.SALESREP_ID,
1235: DECODE(b.SALESREP_ID,NULL,'Y',NULL),
1236: DECODE(b.SALESREP_ID,NULL,
1237: c.ATTRIBUTE_STATUS||'005',c.ATTRIBUTE_STATUS)
1238: FROM RA_SALESREPS b, OE_LINES_IFACE_ALL d
1239: WHERE d.SALESREP = b.NAME(+)
1240: AND sysdate between NVL(start_date_active,sysdate)
1241: and NVL(end_date_active,sysdate)
1242: AND d.rowid = c.rowid

Line 1255: /*UPDATE OE_LINES_IFACE_ALL c

1251:
1252:
1253: -- TAX_EXEMPT_REASON VARCHAR2(30)
1254: -- eBTax changes
1255: /*UPDATE OE_LINES_IFACE_ALL c
1256: SET (TAX_EXEMPT_REASON_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1257: (SELECT b.LOOKUP_CODE,
1258: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1259: DECODE(b.LOOKUP_CODE,NULL,

Line 1261: FROM OE_AR_LOOKUPS_V b, OE_LINES_IFACE_ALL d

1257: (SELECT b.LOOKUP_CODE,
1258: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1259: DECODE(b.LOOKUP_CODE,NULL,
1260: c.ATTRIBUTE_STATUS||'006',c.ATTRIBUTE_STATUS)
1261: FROM OE_AR_LOOKUPS_V b, OE_LINES_IFACE_ALL d
1262: WHERE d.TAX_EXEMPT_REASON = b.MEANING(+)
1263: AND b.LOOKUP_TYPE(+) = 'TAX_REASON'
1264: AND b.enabled_flag(+) = 'Y'
1265: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1276: UPDATE OE_LINES_IFACE_ALL c

1272: WHERE batch_id = p_batch_id)
1273: AND c.TAX_EXEMPT_REASON_CODE IS NULL
1274: AND c.TAX_EXEMPT_REASON IS NOT NULL;*/
1275:
1276: UPDATE OE_LINES_IFACE_ALL c
1277: SET (TAX_EXEMPT_REASON_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1278: (SELECT b.LOOKUP_CODE,
1279: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1280: DECODE(b.LOOKUP_CODE,NULL,

Line 1282: FROM FND_LOOKUPS b, OE_LINES_IFACE_ALL d

1278: (SELECT b.LOOKUP_CODE,
1279: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1280: DECODE(b.LOOKUP_CODE,NULL,
1281: c.ATTRIBUTE_STATUS||'006',c.ATTRIBUTE_STATUS)
1282: FROM FND_LOOKUPS b, OE_LINES_IFACE_ALL d
1283: WHERE d.TAX_EXEMPT_REASON = b.MEANING(+)
1284: AND b.LOOKUP_TYPE(+) = 'ZX_EXEMPTION_REASON_CODE'
1285: AND b.enabled_flag(+) = 'Y'
1286: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1300: UPDATE OE_LINES_IFACE_ALL c

1296:
1297:
1298: -- AGREEMENT VARCHAR2(50)
1299:
1300: UPDATE OE_LINES_IFACE_ALL c
1301: SET (AGREEMENT_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1302: (SELECT b.AGREEMENT_ID,
1303: DECODE(b.AGREEMENT_ID,NULL,'Y',NULL),
1304: DECODE(b.AGREEMENT_ID,NULL,

Line 1306: FROM OE_AGREEMENTS_V b, OE_LINES_IFACE_ALL d

1302: (SELECT b.AGREEMENT_ID,
1303: DECODE(b.AGREEMENT_ID,NULL,'Y',NULL),
1304: DECODE(b.AGREEMENT_ID,NULL,
1305: c.ATTRIBUTE_STATUS||'007',c.ATTRIBUTE_STATUS)
1306: FROM OE_AGREEMENTS_V b, OE_LINES_IFACE_ALL d
1307: WHERE d.AGREEMENT = b.NAME(+)
1308: AND sysdate between nvl(start_date_active, sysdate)
1309: and nvl(end_date_active, sysdate)
1310: AND d.rowid = c.rowid

Line 1323: UPDATE OE_LINES_IFACE_ALL c

1319:
1320:
1321: -- INVOICING_RULE
1322:
1323: UPDATE OE_LINES_IFACE_ALL c
1324: SET (INVOICING_RULE_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1325: (SELECT b.RULE_ID,
1326: DECODE(b.RULE_ID,NULL,'Y',NULL),
1327: DECODE(b.RULE_ID,NULL,

Line 1329: FROM OE_RA_RULES_V b, OE_LINES_IFACE_ALL d

1325: (SELECT b.RULE_ID,
1326: DECODE(b.RULE_ID,NULL,'Y',NULL),
1327: DECODE(b.RULE_ID,NULL,
1328: c.ATTRIBUTE_STATUS||'008',c.ATTRIBUTE_STATUS)
1329: FROM OE_RA_RULES_V b, OE_LINES_IFACE_ALL d
1330: WHERE d.INVOICING_RULE = b.NAME(+)
1331: AND b.STATUS(+) = 'A'
1332: AND b.TYPE(+) = 'I'
1333: AND d.rowid = c.rowid

Line 1344: UPDATE OE_LINES_IFACE_ALL c

1340: AND c.INVOICING_RULE IS NOT NULL;
1341:
1342: -- ACCOUNTING_RULE VARCHAR2(30)
1343:
1344: UPDATE OE_LINES_IFACE_ALL c
1345: SET (ACCOUNTING_RULE_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1346: (SELECT b.RULE_ID,
1347: DECODE(b.RULE_ID,NULL,'Y',NULL),
1348: DECODE(b.RULE_ID,NULL,

Line 1350: FROM OE_RA_RULES_V b, OE_LINES_IFACE_ALL d

1346: (SELECT b.RULE_ID,
1347: DECODE(b.RULE_ID,NULL,'Y',NULL),
1348: DECODE(b.RULE_ID,NULL,
1349: c.ATTRIBUTE_STATUS||'009',c.ATTRIBUTE_STATUS)
1350: FROM OE_RA_RULES_V b, OE_LINES_IFACE_ALL d
1351: WHERE d.ACCOUNTING_RULE = b.NAME(+)
1352: AND b.STATUS(+) = 'A'
1353: -- AND b.TYPE(+) = 'A' --we now allow variable accounting rules
1354: AND d.rowid = c.rowid

Line 1365: UPDATE OE_LINES_IFACE_ALL c

1361: AND c.ACCOUNTING_RULE IS NOT NULL;
1362:
1363: -- PAYMENT_TERM VARCHAR2(30)
1364:
1365: UPDATE OE_LINES_IFACE_ALL c
1366: SET (PAYMENT_TERM_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1367: (SELECT b.TERM_ID,
1368: DECODE(b.TERM_ID,NULL,'Y',NULL),
1369: DECODE(b.TERM_ID,NULL,

Line 1371: FROM OE_RA_TERMS_V b, OE_LINES_IFACE_ALL d

1367: (SELECT b.TERM_ID,
1368: DECODE(b.TERM_ID,NULL,'Y',NULL),
1369: DECODE(b.TERM_ID,NULL,
1370: c.ATTRIBUTE_STATUS||'010',c.ATTRIBUTE_STATUS)
1371: FROM OE_RA_TERMS_V b, OE_LINES_IFACE_ALL d
1372: WHERE d.PAYMENT_TERM = b.NAME(+)
1373: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1374: AND NVL(END_DATE_ACTIVE, SYSDATE)
1375: AND d.rowid = c.rowid

Line 1387: UPDATE OE_LINES_IFACE_ALL c

1383:
1384:
1385: -- FREIGHT_TERMS VARCHAR2(30)
1386:
1387: UPDATE OE_LINES_IFACE_ALL c
1388: SET (FREIGHT_TERMS_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1389: (SELECT b.LOOKUP_CODE,
1390: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1391: DECODE(b.LOOKUP_CODE,NULL,

Line 1393: FROM OE_LOOKUPS b, OE_LINES_IFACE_ALL d

1389: (SELECT b.LOOKUP_CODE,
1390: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1391: DECODE(b.LOOKUP_CODE,NULL,
1392: c.ATTRIBUTE_STATUS||'011',c.ATTRIBUTE_STATUS)
1393: FROM OE_LOOKUPS b, OE_LINES_IFACE_ALL d
1394: WHERE d.FREIGHT_TERMS = b.MEANING(+)
1395: AND b.LOOKUP_TYPE(+) = 'FREIGHT_TERMS'
1396: AND b.enabled_flag(+) = 'Y'
1397: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1412: UPDATE OE_LINES_IFACE_ALL c

1408:
1409:
1410: -- FOB_POINT VARCHAR2(30)
1411:
1412: UPDATE OE_LINES_IFACE_ALL c
1413: SET (FOB_POINT_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1414: (SELECT b.LOOKUP_CODE,
1415: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1416: DECODE(b.LOOKUP_CODE,NULL,

Line 1418: FROM OE_AR_LOOKUPS_V b, OE_LINES_IFACE_ALL d

1414: (SELECT b.LOOKUP_CODE,
1415: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1416: DECODE(b.LOOKUP_CODE,NULL,
1417: c.ATTRIBUTE_STATUS||'012',c.ATTRIBUTE_STATUS)
1418: FROM OE_AR_LOOKUPS_V b, OE_LINES_IFACE_ALL d
1419: WHERE d.FOB_POINT = b.MEANING(+)
1420: AND b.LOOKUP_TYPE(+) = 'FOB'
1421: AND b.enabled_flag(+) = 'Y'
1422: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1436: UPDATE OE_LINES_IFACE_ALL c

1432:
1433:
1434: -- SOLD_TO_ORG -- Required as it is used later for invoice
1435: -- and ship to org
1436: UPDATE OE_LINES_IFACE_ALL c
1437: SET SOLD_TO_ORG_ID =
1438: (SELECT d.SOLD_TO_ORG_ID FROM OE_HEADERS_IFACE_ALL d, OE_LINES_IFACE_ALL e
1439: WHERE d.order_source_id = e.order_source_id
1440: AND d.orig_sys_document_ref = e.orig_sys_document_ref

Line 1438: (SELECT d.SOLD_TO_ORG_ID FROM OE_HEADERS_IFACE_ALL d, OE_LINES_IFACE_ALL e

1434: -- SOLD_TO_ORG -- Required as it is used later for invoice
1435: -- and ship to org
1436: UPDATE OE_LINES_IFACE_ALL c
1437: SET SOLD_TO_ORG_ID =
1438: (SELECT d.SOLD_TO_ORG_ID FROM OE_HEADERS_IFACE_ALL d, OE_LINES_IFACE_ALL e
1439: WHERE d.order_source_id = e.order_source_id
1440: AND d.orig_sys_document_ref = e.orig_sys_document_ref
1441: AND batch_id = p_batch_id
1442: AND d.sold_to_org_id IS NOT NULL

Line 1466: UPDATE OE_LINES_IFACE_ALL c

1462:
1463: -- SHIP_TO_CUSTOMER
1464: --Enclosing the update in a block for bug 5620045
1465: BEGIN
1466: UPDATE OE_LINES_IFACE_ALL c
1467: SET (SHIP_TO_CUSTOMER_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1468: (SELECT b.CUST_ACCOUNT_ID,
1469: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1470: DECODE(b.CUST_ACCOUNT_ID,NULL,

Line 1472: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d

1468: (SELECT b.CUST_ACCOUNT_ID,
1469: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1470: DECODE(b.CUST_ACCOUNT_ID,NULL,
1471: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
1472: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d
1473: WHERE d.SHIP_TO_CUSTOMER_NUMBER IS NOT NULL
1474: AND d.SHIP_TO_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
1475: AND b.STATUS(+) = 'A'
1476: AND d.rowid = c.rowid

Line 1482: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d

1478: SELECT b.CUST_ACCOUNT_ID,
1479: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1480: DECODE(b.CUST_ACCOUNT_ID,NULL,
1481: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
1482: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d
1483: WHERE d.SHIP_TO_CUSTOMER_NUMBER IS NULL
1484: AND d.SHIP_TO_CUSTOMER_NAME = e.PARTY_NAME(+)
1485: AND b.STATUS(+) = 'A'
1486: AND b.PARTY_ID(+) = e.PARTY_ID

Line 1498: UPDATE OE_LINES_IFACE_ALL c

1494: AND (c.SHIP_TO_CUSTOMER_NAME IS NOT NULL OR
1495: c.SHIP_TO_CUSTOMER_NUMBER IS NOT NULL);
1496: EXCEPTION
1497: WHEN subqry_too_many_rows THEN
1498: UPDATE OE_LINES_IFACE_ALL c
1499: SET ERROR_FLAG = 'Y',
1500: ATTRIBUTE_STATUS = ATTRIBUTE_STATUS||'014'
1501: WHERE c.SHIP_TO_CUSTOMER_ID IS NULL
1502: AND c.SHIP_TO_CUSTOMER_NAME IS NOT NULL

Line 1513: UPDATE OE_LINES_IFACE_ALL c

1509:
1510: -- INVOICE_TO_CUSTOMER
1511: -- Catch subqry_too_many_rows exception bug 5620045
1512: BEGIN
1513: UPDATE OE_LINES_IFACE_ALL c
1514: SET (INVOICE_TO_CUSTOMER_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1515: (SELECT b.CUST_ACCOUNT_ID,
1516: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1517: DECODE(b.CUST_ACCOUNT_ID,NULL,

Line 1519: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d

1515: (SELECT b.CUST_ACCOUNT_ID,
1516: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1517: DECODE(b.CUST_ACCOUNT_ID,NULL,
1518: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
1519: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d
1520: WHERE d.INVOICE_TO_CUSTOMER_NUMBER IS NOT NULL
1521: AND d.INVOICE_TO_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
1522: AND b.STATUS(+) = 'A'
1523: AND d.rowid = c.rowid

Line 1529: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d

1525: SELECT b.CUST_ACCOUNT_ID,
1526: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1527: DECODE(b.CUST_ACCOUNT_ID,NULL,
1528: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
1529: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d
1530: WHERE d.INVOICE_TO_CUSTOMER_NUMBER IS NULL
1531: AND d.INVOICE_TO_CUSTOMER_NAME = e.PARTY_NAME(+)
1532: AND b.STATUS(+) = 'A'
1533: AND b.PARTY_ID(+) = e.PARTY_ID

Line 1545: UPDATE OE_LINES_IFACE_ALL c

1541: AND (c.INVOICE_TO_CUSTOMER_NAME IS NOT NULL OR
1542: c.INVOICE_TO_CUSTOMER_NUMBER IS NOT NULL);
1543: EXCEPTION
1544: WHEN subqry_too_many_rows THEN
1545: UPDATE OE_LINES_IFACE_ALL c
1546: SET ERROR_FLAG = 'Y',
1547: ATTRIBUTE_STATUS = ATTRIBUTE_STATUS||'015'
1548: WHERE (order_source_id, orig_sys_document_ref) IN
1549: ( SELECT order_source_id, orig_sys_document_ref

Line 1560: UPDATE OE_LINES_IFACE_ALL c

1556: END IF;
1557:
1558: -- SHIP_TO_ORG
1559:
1560: UPDATE OE_LINES_IFACE_ALL c
1561: SET (SHIP_TO_ORG_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1562: (SELECT /*+ PUSH_PRED(b) */ b.ORGANIZATION_ID,
1563: DECODE(b.ORGANIZATION_ID,NULL,'Y',NULL),
1564: DECODE(b.ORGANIZATION_ID,NULL,

Line 1566: FROM OE_SHIP_TO_ORGS_V b, OE_LINES_IFACE_ALL d

1562: (SELECT /*+ PUSH_PRED(b) */ b.ORGANIZATION_ID,
1563: DECODE(b.ORGANIZATION_ID,NULL,'Y',NULL),
1564: DECODE(b.ORGANIZATION_ID,NULL,
1565: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
1566: FROM OE_SHIP_TO_ORGS_V b, OE_LINES_IFACE_ALL d
1567: WHERE d.ship_to_address1 = ADDRESS_LINE_1(+)
1568: AND nvl(d.ship_to_address2,'NIL') = NVL(ADDRESS_LINE_2(+),'NIL')
1569: AND nvl(d.ship_to_address3,'NIL') = nvl(ADDRESS_LINE_3(+),'NIL')
1570: --AND nvl(d.ship_to_address4,'NIL') = ADDRESS_LINE_4

Line 1593: UPDATE OE_LINES_IFACE_ALL c

1589: );
1590:
1591: -- INVOICE_TO_ORG
1592:
1593: UPDATE OE_LINES_IFACE_ALL c
1594: SET (INVOICE_TO_ORG_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1595: (SELECT /*+ PUSH_PRED(b) */ b.ORGANIZATION_ID,
1596: DECODE(b.ORGANIZATION_ID,NULL,'Y',NULL),
1597: DECODE(b.ORGANIZATION_ID,NULL,

Line 1599: FROM OE_INVOICE_TO_ORGS_V b, OE_LINES_IFACE_ALL d

1595: (SELECT /*+ PUSH_PRED(b) */ b.ORGANIZATION_ID,
1596: DECODE(b.ORGANIZATION_ID,NULL,'Y',NULL),
1597: DECODE(b.ORGANIZATION_ID,NULL,
1598: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
1599: FROM OE_INVOICE_TO_ORGS_V b, OE_LINES_IFACE_ALL d
1600: WHERE d.invoice_to_address1 = ADDRESS_LINE_1(+)
1601: AND nvl(d.invoice_to_address2,'NIL') = NVL(ADDRESS_LINE_2(+),'NIL')
1602: AND nvl(d.invoice_to_address3,'NIL') = nvl(ADDRESS_LINE_3(+),'NIL')
1603: --AND nvl(d.invoice_to_address4,'NIL') = ADDRESS_LINE_4

Line 1627: UPDATE OE_LINES_IFACE_ALL c

1623:
1624:
1625: -- SHIP_TO_CONTACT VARCHAR2(30)
1626:
1627: UPDATE OE_LINES_IFACE_ALL c
1628: SET (SHIP_TO_CONTACT_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
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,

Line 1645: UPDATE OE_LINES_IFACE_ALL c

1641:
1642:
1643: -- INVOICE_TO_CONTACT VARCHAR2(30)
1644:
1645: UPDATE OE_LINES_IFACE_ALL c
1646: SET (INVOICE_TO_CONTACT_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
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,

Line 1663: UPDATE OE_LINES_IFACE_ALL c

1659:
1660:
1661: -- DELIVER_TO_CONTACT VARCHAR2(30)
1662:
1663: UPDATE OE_LINES_IFACE_ALL c
1664: SET (DELIVER_TO_CONTACT_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
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,

Line 1683: UPDATE OE_LINES_IFACE_ALL c

1679:
1680:
1681: -- SHIPMENT_PRIORITY_CODE
1682:
1683: UPDATE OE_LINES_IFACE_ALL c
1684: SET (SHIPMENT_PRIORITY_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1685: (SELECT b.LOOKUP_CODE,
1686: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1687: DECODE(b.LOOKUP_CODE,NULL,

Line 1689: FROM OE_LOOKUPS b, OE_LINES_IFACE_ALL d

1685: (SELECT b.LOOKUP_CODE,
1686: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1687: DECODE(b.LOOKUP_CODE,NULL,
1688: c.ATTRIBUTE_STATUS||'023',c.ATTRIBUTE_STATUS)
1689: FROM OE_LOOKUPS b, OE_LINES_IFACE_ALL d
1690: WHERE d.SHIPMENT_PRIORITY = b.MEANING(+)
1691: AND b.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
1692: AND b.enabled_flag(+) = 'Y'
1693: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1708: UPDATE OE_LINES_IFACE_ALL c

1704:
1705: -- DEMAND_BUCKET_TYPE: No value to ID conversion in OEXSVIDB.pls
1706:
1707: -- SHIPPING_METHOD_CODE VARCHAR2(30)
1708: UPDATE OE_LINES_IFACE_ALL c
1709: SET (SHIPPING_METHOD_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1710: (SELECT b.LOOKUP_CODE,
1711: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1712: DECODE(b.LOOKUP_CODE,NULL,

Line 1714: FROM OE_SHIP_METHODS_V b, OE_LINES_IFACE_ALL d

1710: (SELECT b.LOOKUP_CODE,
1711: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1712: DECODE(b.LOOKUP_CODE,NULL,
1713: c.ATTRIBUTE_STATUS||'024',c.ATTRIBUTE_STATUS)
1714: FROM OE_SHIP_METHODS_V b, OE_LINES_IFACE_ALL d
1715: WHERE d.SHIPPING_METHOD = b.MEANING(+)
1716: AND b.enabled_flag(+) = 'Y'
1717: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1718: AND NVL(END_DATE_ACTIVE, SYSDATE)

Line 1761: UPDATE OE_LINES_IFACE_ALL c

1757: -- Catch subqry_too_many_rows exception and add additional where clause
1758: -- to update only the records in the current batch
1759:
1760: BEGIN
1761: UPDATE OE_LINES_IFACE_ALL c
1762: SET (END_CUSTOMER_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1763: (SELECT b.CUST_ACCOUNT_ID,
1764: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1765: DECODE(b.CUST_ACCOUNT_ID,NULL,

Line 1767: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d

1763: (SELECT b.CUST_ACCOUNT_ID,
1764: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1765: DECODE(b.CUST_ACCOUNT_ID,NULL,
1766: d.ATTRIBUTE_STATUS||'025',d.ATTRIBUTE_STATUS)
1767: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d
1768: WHERE d.END_CUSTOMER_NUMBER IS NOT NULL
1769: AND d.END_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
1770: AND b.STATUS(+) = 'A' AND d.rowid = c.rowid
1771: UNION ALL

Line 1776: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d

1772: SELECT b.CUST_ACCOUNT_ID,
1773: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1774: DECODE(b.CUST_ACCOUNT_ID,NULL,
1775: d.ATTRIBUTE_STATUS||'025',d.ATTRIBUTE_STATUS)
1776: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d
1777: WHERE d.END_CUSTOMER_NUMBER IS NULL
1778: AND d.END_CUSTOMER_NAME = e.PARTY_NAME(+)
1779: AND b.STATUS(+) = 'A' AND b.PARTY_ID(+) = e.PARTY_ID
1780: AND d.rowid = c.rowid)

Line 1790: UPDATE OE_LINES_IFACE_ALL c

1786: AND (c.END_CUSTOMER_NAME IS NOT NULL
1787: OR c.END_CUSTOMER_NUMBER IS NOT NULL);
1788: EXCEPTION
1789: WHEN subqry_too_many_rows THEN
1790: UPDATE OE_LINES_IFACE_ALL c
1791: SET ERROR_FLAG = 'Y',
1792: ATTRIBUTE_STATUS = ATTRIBUTE_STATUS||'025'
1793: WHERE (order_source_id, orig_sys_document_ref) IN
1794: ( SELECT order_source_id, orig_sys_document_ref

Line 1805: UPDATE OE_LINES_IFACE_ALL c

1801:
1802:
1803: --bug 5620045 added additional where clause to update records in current
1804: --batch
1805: UPDATE OE_LINES_IFACE_ALL c
1806: SET (END_CUSTOMER_CONTACT_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1807: (SELECT
1808: Get_End_customer_Contact_ID(c.END_CUSTOMER_CONTACT,c.END_CUSTOMER_ID),
1809: DECODE(Get_End_customer_Contact_ID(c.END_CUSTOMER_CONTACT,

Line 1824: UPDATE OE_LINES_IFACE_ALL c

1820: AND c.END_CUSTOMER_CONTACT IS NOT NULL;
1821:
1822:
1823:
1824: UPDATE OE_LINES_IFACE_ALL c
1825: SET (END_CUSTOMER_SITE_USE_ID,ERROR_FLAG,ATTRIBUTE_STATUS)=
1826: (SELECT END_CUSTOMER_SITE(c.end_customer_address1,
1827: c.end_customer_address2,c.end_customer_address3,
1828: c.end_customer_address4,c.end_customer_location, NULL,

Line 1864: UPDATE OE_LINES_IFACE_ALL c

1860:
1861:
1862:
1863: -- Bug 5054618}
1864: UPDATE OE_LINES_IFACE_ALL c
1865: SET (IB_OWNER_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1866: (SELECT b.LOOKUP_CODE,
1867: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1868: DECODE(b.LOOKUP_CODE,NULL,

Line 1877: OE_LINES_IFACE_ALL d

1873: where lookup_type In ('ITEM_OWNER', 'ONT_INSTALL_BASE')
1874: and enabled_flag = 'Y'
1875: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1876: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,
1877: OE_LINES_IFACE_ALL d
1878: WHERE d.IB_OWNER = b.MEANING(+)
1879: --AND ( b.LOOKUP_TYPE(+) = 'ITEM_OWNER'
1880: --OR b.LOOKUP_TYPE(+) = 'ONT_INSTALL_BASE' )
1881: --AND b.enabled_flag(+) = 'Y'

Line 1895: UPDATE OE_LINES_IFACE_ALL c

1891: AND c.IB_OWNER_CODE IS NULL
1892: AND c.IB_OWNER IS NOT NULL;
1893:
1894:
1895: UPDATE OE_LINES_IFACE_ALL c
1896: SET (IB_INSTALLED_AT_LOCATION_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1897: (SELECT b.LOOKUP_CODE,
1898: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1899: DECODE(b.LOOKUP_CODE,NULL,

Line 1908: OE_LINES_IFACE_ALL d

1904: where lookup_type In ('ITEM_INSTALL_LOCATION', 'ONT_INSTALL_BASE')
1905: and enabled_flag = 'Y'
1906: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1907: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,
1908: OE_LINES_IFACE_ALL d
1909: WHERE d.IB_INSTALLED_AT_LOCATION = b.MEANING(+)
1910: --AND ( b.LOOKUP_TYPE(+) = 'ITEM_INSTALL_LOCATION'
1911: --OR b.LOOKUP_TYPE(+) = 'ONT_INSTALL_BASE' )
1912: --AND b.enabled_flag(+) = 'Y'

Line 1925: UPDATE OE_LINES_IFACE_ALL c

1921: WHERE batch_id = p_batch_id)
1922: AND c.IB_INSTALLED_AT_LOCATION_CODE IS NULL
1923: AND c.IB_INSTALLED_AT_LOCATION IS NOT NULL;
1924:
1925: UPDATE OE_LINES_IFACE_ALL c
1926: SET (IB_CURRENT_LOCATION_CODE,ERROR_FLAG,ATTRIBUTE_STATUS)=
1927: (SELECT b.LOOKUP_CODE,
1928: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1929: DECODE(b.LOOKUP_CODE,NULL,

Line 1938: OE_LINES_IFACE_ALL d

1934: where lookup_type In ('ITEM_CURRENT_LOCATION', 'ONT_INSTALL_BASE')
1935: and enabled_flag = 'Y'
1936: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1937: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,
1938: OE_LINES_IFACE_ALL d
1939: WHERE d.IB_CURRENT_LOCATION = b.MEANING(+)
1940: --AND ( b.LOOKUP_TYPE(+) = 'ITEM_CURRENT_LOCATION'
1941: --OR b.LOOKUP_TYPE(+) = 'ONT_INSTALL_BASE' )
1942: --AND b.enabled_flag(+) = 'Y'

Line 2098: FROM OE_LINES_IFACE_ALL

2094: orig_sys_line_ref,
2095: orig_sys_shipment_ref ,
2096: change_sequence,
2097: attribute_status
2098: FROM OE_LINES_IFACE_ALL
2099: WHERE (order_source_id, orig_sys_document_ref) IN
2100: ( SELECT order_source_id, orig_sys_document_ref
2101: FROM OE_HEADERS_IFACE_ALL
2102: WHERE batch_id = p_batch_id)