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.

[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_ITEM_ASSOCIATIONS

Line 1380: -- pk1_value exists in ego_item_associations for this item --

1376: END LOOP; -- FOR i IN c_data_levels LOOP
1377:
1378: ----------------------------------------------------------------
1379: -- Next, validate the Item Supplier attrs. Validate that the --
1380: -- pk1_value exists in ego_item_associations for this item --
1381: ----------------------------------------------------------------
1382: IF p_validate_only = FND_API.G_FALSE THEN
1383: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1384: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER

Line 1402: FROM EGO_ITEM_ASSOCIATIONS eia

1398: OR
1399: ( uai2.PK1_VALUE IS NOT NULL
1400: AND uai2.PK2_VALUE IS NULL
1401: AND NOT EXISTS (SELECT NULL
1402: FROM EGO_ITEM_ASSOCIATIONS eia
1403: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1404: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1405: AND eia.PK1_VALUE = uai2.PK1_VALUE
1406: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID

Line 1431: FROM EGO_ITEM_ASSOCIATIONS eia

1427: OR
1428: ( uai2.PK1_VALUE IS NOT NULL
1429: AND uai2.PK2_VALUE IS NULL
1430: AND NOT EXISTS (SELECT NULL
1431: FROM EGO_ITEM_ASSOCIATIONS eia
1432: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1433: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1434: AND eia.PK1_VALUE = uai2.PK1_VALUE
1435: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID

Line 1438: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

1434: AND eia.PK1_VALUE = uai2.PK1_VALUE
1435: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID
1436: UNION ALL
1437: SELECT NULL
1438: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
1439: WHERE eiai.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1440: AND eiai.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1441: AND eiai.PK1_VALUE = uai2.PK1_VALUE
1442: AND eiai.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID

Line 1453: -- the pk2_value exists in ego_item_associations for this item --

1449: END IF;
1450:
1451: -----------------------------------------------------------------
1452: -- Next, validate the Item Supplier site attrs. Validate that --
1453: -- the pk2_value exists in ego_item_associations for this item --
1454: -----------------------------------------------------------------
1455: IF p_validate_only = FND_API.G_FALSE THEN
1456: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1457: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER_SITE

Line 1473: FROM EGO_ITEM_ASSOCIATIONS eia

1469: OR
1470: ( uai2.PK1_VALUE IS NOT NULL
1471: AND uai2.PK2_VALUE IS NOT NULL
1472: AND NOT EXISTS (SELECT NULL
1473: FROM EGO_ITEM_ASSOCIATIONS eia
1474: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1475: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1476: AND eia.PK1_VALUE = uai2.PK1_VALUE
1477: AND eia.PK2_VALUE = uai2.PK2_VALUE

Line 1501: FROM EGO_ITEM_ASSOCIATIONS eia

1497: OR
1498: ( uai2.PK1_VALUE IS NOT NULL
1499: AND uai2.PK2_VALUE IS NOT NULL
1500: AND NOT EXISTS (SELECT NULL
1501: FROM EGO_ITEM_ASSOCIATIONS eia
1502: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1503: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1504: AND eia.PK1_VALUE = uai2.PK1_VALUE
1505: AND eia.PK2_VALUE = uai2.PK2_VALUE

Line 1509: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

1505: AND eia.PK2_VALUE = uai2.PK2_VALUE
1506: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID
1507: UNION ALL
1508: SELECT NULL
1509: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
1510: WHERE eiai.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1511: AND eiai.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1512: AND eiai.PK1_VALUE = uai2.PK1_VALUE
1513: AND eiai.PK2_VALUE = uai2.PK2_VALUE

Line 1527: -- in ego_item_associations for this item --

1523:
1524: ------------------------------------------------------------------
1525: -- Next, validate the Item Supplier site Org attrs. Validate --
1526: -- that the pk1,pk2_value along with the organization_id exists --
1527: -- in ego_item_associations for this item --
1528: ------------------------------------------------------------------
1529: IF p_validate_only = FND_API.G_FALSE THEN
1530: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1531: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER_SITE_ORG

Line 1547: FROM EGO_ITEM_ASSOCIATIONS eia

1543: OR
1544: ( uai2.PK1_VALUE IS NOT NULL
1545: AND uai2.PK2_VALUE IS NOT NULL
1546: AND NOT EXISTS (SELECT NULL
1547: FROM EGO_ITEM_ASSOCIATIONS eia
1548: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1549: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1550: AND eia.PK1_VALUE = uai2.PK1_VALUE
1551: AND eia.PK2_VALUE = uai2.PK2_VALUE

Line 1575: FROM EGO_ITEM_ASSOCIATIONS eia

1571: OR
1572: ( uai2.PK1_VALUE IS NOT NULL
1573: AND uai2.PK2_VALUE IS NOT NULL
1574: AND NOT EXISTS (SELECT NULL
1575: FROM EGO_ITEM_ASSOCIATIONS eia
1576: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1577: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1578: AND eia.PK1_VALUE = uai2.PK1_VALUE
1579: AND eia.PK2_VALUE = uai2.PK2_VALUE

Line 1583: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

1579: AND eia.PK2_VALUE = uai2.PK2_VALUE
1580: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID
1581: UNION ALL
1582: SELECT NULL
1583: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
1584: WHERE eiai.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1585: AND eiai.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1586: AND eiai.PK1_VALUE = uai2.PK1_VALUE
1587: AND eiai.PK2_VALUE = uai2.PK2_VALUE