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.EGO_GTIN_PVT dependencies on MTL_SYSTEM_ITEMS

Line 66: MTL_SYSTEM_ITEMS_B MSI,

62: SELECT 1
63: FROM MTL_CUSTOMER_ITEMS MCI,
64: MTL_CUSTOMER_ITEM_XREFS MCIX,
65: MTL_CROSS_REFERENCES MCR,
66: MTL_SYSTEM_ITEMS_B MSI,
67: MTL_PARAMETERS MP
68: WHERE MSI.INVENTORY_ITEM_ID = p_inventory_item_id
69: AND MSI.ORGANIZATION_ID = p_org_id
70: AND MSI.INVENTORY_ITEM_ID = MCIX.INVENTORY_ITEM_ID

Line 934: MTL_SYSTEM_ITEMS_B MSI,

930: l_temp VARCHAR2(1);
931: BEGIN
932: SELECT 'X' INTO l_temp
933: FROM MTL_CROSS_REFERENCES MCR,
934: MTL_SYSTEM_ITEMS_B MSI,
935: MTL_PARAMETERS MP
936: WHERE MCR.CROSS_REFERENCE_TYPE = 'GTIN'
937: AND MCR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
938: AND NVL(MCR.ORGANIZATION_ID, MSI.ORGANIZATION_ID) = MSI.ORGANIZATION_ID

Line 1281: l_trade_unit_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;

1277: ( p_inventory_item_id IN NUMBER
1278: , p_org_id IN NUMBER
1279: ) RETURN VARCHAR2
1280: IS
1281: l_trade_unit_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1282: l_ret_code VARCHAR2(100);
1283: BEGIN
1284: l_ret_code := FND_API.G_TRUE;
1285:

Line 1288: FROM MTL_SYSTEM_ITEMS_B

1284: l_ret_code := FND_API.G_TRUE;
1285:
1286: SELECT TRADE_ITEM_DESCRIPTOR
1287: INTO l_trade_unit_desc
1288: FROM MTL_SYSTEM_ITEMS_B
1289: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1290: AND ORGANIZATION_ID = p_org_id;
1291:
1292: IF NVL(l_trade_unit_desc,'BASE_UNIT_OR_EACH') <> 'BASE_UNIT_OR_EACH' THEN

Line 1463: FROM MTL_CROSS_REFERENCES MCR, MTL_SYSTEM_ITEMS_B MSIB

1459: ELSIF p_attribute_names.COUNT > 0 AND (l_tp_attr_updated AND (NOT l_non_tp_attr_updated) ) THEN
1460: -- getting GTIN of item
1461: BEGIN
1462: SELECT CROSS_REFERENCE INTO l_gtin
1463: FROM MTL_CROSS_REFERENCES MCR, MTL_SYSTEM_ITEMS_B MSIB
1464: WHERE MCR.CROSS_REFERENCE_TYPE = 'GTIN'
1465: AND MCR.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
1466: AND MSIB.PRIMARY_UOM_CODE = MCR.UOM_CODE
1467: AND MSIB.ORGANIZATION_ID = p_organization_id

Line 1774: FROM MTL_SYSTEM_ITEMS_INTERFACE

1770: weight_uom_code,
1771: volume_uom_code,
1772: shelf_life_days,
1773: trade_item_descriptor
1774: FROM MTL_SYSTEM_ITEMS_INTERFACE
1775: WHERE (SET_PROCESS_ID = p_set_id OR SET_PROCESS_ID = p_set_id + 1000000000000)
1776: AND TRANSACTION_TYPE IN ('UPDATE', 'AUTO_CHILD')
1777: AND PROCESS_FLAG = 4;
1778:

Line 1780: l_unit_length MTL_SYSTEM_ITEMS.UNIT_LENGTH%TYPE := NULL;

1776: AND TRANSACTION_TYPE IN ('UPDATE', 'AUTO_CHILD')
1777: AND PROCESS_FLAG = 4;
1778:
1779: l_msib_rowid ROWID;
1780: l_unit_length MTL_SYSTEM_ITEMS.UNIT_LENGTH%TYPE := NULL;
1781: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
1782: l_unit_width MTL_SYSTEM_ITEMS.UNIT_WIDTH%TYPE := NULL;
1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;
1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;

Line 1781: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;

1777: AND PROCESS_FLAG = 4;
1778:
1779: l_msib_rowid ROWID;
1780: l_unit_length MTL_SYSTEM_ITEMS.UNIT_LENGTH%TYPE := NULL;
1781: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
1782: l_unit_width MTL_SYSTEM_ITEMS.UNIT_WIDTH%TYPE := NULL;
1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;
1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;
1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;

Line 1782: l_unit_width MTL_SYSTEM_ITEMS.UNIT_WIDTH%TYPE := NULL;

1778:
1779: l_msib_rowid ROWID;
1780: l_unit_length MTL_SYSTEM_ITEMS.UNIT_LENGTH%TYPE := NULL;
1781: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
1782: l_unit_width MTL_SYSTEM_ITEMS.UNIT_WIDTH%TYPE := NULL;
1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;
1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;
1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;
1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;

Line 1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;

1779: l_msib_rowid ROWID;
1780: l_unit_length MTL_SYSTEM_ITEMS.UNIT_LENGTH%TYPE := NULL;
1781: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
1782: l_unit_width MTL_SYSTEM_ITEMS.UNIT_WIDTH%TYPE := NULL;
1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;
1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;
1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;
1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;
1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;

Line 1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;

1780: l_unit_length MTL_SYSTEM_ITEMS.UNIT_LENGTH%TYPE := NULL;
1781: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
1782: l_unit_width MTL_SYSTEM_ITEMS.UNIT_WIDTH%TYPE := NULL;
1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;
1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;
1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;
1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;
1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;
1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;

Line 1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;

1781: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
1782: l_unit_width MTL_SYSTEM_ITEMS.UNIT_WIDTH%TYPE := NULL;
1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;
1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;
1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;
1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;
1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;
1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;
1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;

Line 1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;

1782: l_unit_width MTL_SYSTEM_ITEMS.UNIT_WIDTH%TYPE := NULL;
1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;
1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;
1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;
1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;
1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;
1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;
1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;
1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;

Line 1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;

1783: l_unit_height MTL_SYSTEM_ITEMS.UNIT_HEIGHT%TYPE := NULL;
1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;
1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;
1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;
1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;
1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;
1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;
1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;
1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653

Line 1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;

1784: l_unit_volume MTL_SYSTEM_ITEMS.UNIT_VOLUME%TYPE := NULL;
1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;
1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;
1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;
1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;
1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;
1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;
1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653
1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782

Line 1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;

1785: l_dimension_uom_code MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE%TYPE := NULL;
1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;
1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;
1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;
1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;
1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;
1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653
1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782
1793: l_shelf_life_days MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS%TYPE := NULL; -- Bug: 5254856

Line 1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;

1786: l_list_price_per_unit MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT%TYPE := NULL;
1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;
1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;
1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;
1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;
1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653
1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782
1793: l_shelf_life_days MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS%TYPE := NULL; -- Bug: 5254856
1794: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;

Line 1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653

1787: l_shippable_item_flag MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG%TYPE := NULL;
1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;
1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;
1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;
1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653
1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782
1793: l_shelf_life_days MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS%TYPE := NULL; -- Bug: 5254856
1794: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1795:

Line 1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782

1788: l_invoiceable_item_flag MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG%TYPE := NULL;
1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;
1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;
1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653
1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782
1793: l_shelf_life_days MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS%TYPE := NULL; -- Bug: 5254856
1794: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1795:
1796: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);

Line 1793: l_shelf_life_days MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS%TYPE := NULL; -- Bug: 5254856

1789: l_customer_order_enabled_flag MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG%TYPE := NULL;
1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;
1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653
1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782
1793: l_shelf_life_days MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS%TYPE := NULL; -- Bug: 5254856
1794: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1795:
1796: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
1797:

Line 1794: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;

1790: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE := NULL;
1791: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL; -- Bug: 3874653
1792: l_volume_uom_code MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE%TYPE := NULL; -- Bug: 3921782
1793: l_shelf_life_days MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS%TYPE := NULL; -- Bug: 5254856
1794: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1795:
1796: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
1797:
1798: k BINARY_INTEGER := 0;

Line 1826: FROM MTL_SYSTEM_ITEMS_B

1822: l_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
1823: -- find whether updated item is an UCCnet enabled item or not
1824: BEGIN
1825: SELECT GDSN_OUTBOUND_ENABLED_FLAG INTO l_gdsn_outbound_enabled_flag
1826: FROM MTL_SYSTEM_ITEMS_B
1827: WHERE INVENTORY_ITEM_ID = i.inventory_item_id
1828: AND ORGANIZATION_ID = i.organization_id;
1829: EXCEPTION
1830: WHEN NO_DATA_FOUND THEN

Line 1874: FROM MTL_SYSTEM_ITEMS_B msib, MTL_SYSTEM_ITEMS_TL msit

1870: l_weight_uom_code,
1871: l_volume_uom_code,
1872: l_shelf_life_days,
1873: l_trade_item_desc
1874: FROM MTL_SYSTEM_ITEMS_B msib, MTL_SYSTEM_ITEMS_TL msit
1875: WHERE msib.INVENTORY_ITEM_ID = i.inventory_item_id
1876: AND msib.ORGANIZATION_ID = i.organization_id
1877: AND msib.INVENTORY_ITEM_ID = msit.INVENTORY_ITEM_ID
1878: AND msib.ORGANIZATION_ID = msit.ORGANIZATION_ID

Line 2045: UPDATE MTL_SYSTEM_ITEMS_B

2041: END IF;
2042:
2043: IF k > 0 THEN
2044: IF l_msib_upd_reqd THEN
2045: UPDATE MTL_SYSTEM_ITEMS_B
2046: SET
2047: UNIT_WEIGHT = i.unit_weight,
2048: CUSTOMER_ORDER_ENABLED_FLAG = i.customer_order_enabled_flag,
2049: WEIGHT_UOM_CODE = i.weight_uom_code -- Bug: 3874653

Line 2063: FROM mtl_system_items_b

2059:
2060: -- issue query against MSIB for item_cat_group_id, value for item_id, org_id
2061: SELECT item_catalog_group_id
2062: INTO l_item_catalog_group_id
2063: FROM mtl_system_items_b
2064: WHERE inventory_item_id = i.inventory_item_id
2065: AND organization_id = i.organization_id;
2066:
2067: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 2097: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

2093: x_msg_data => l_msg_text);
2094:
2095: write_debug_log('After calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES from IOI ... return_status, error = '||l_return_status||' , '||l_msg_text);
2096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2097: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
2098: SET process_flag = 3
2099: WHERE rowid = i.rowid;
2100:
2101: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 2111: ,'MTL_SYSTEM_ITEMS_INTERFACE'

2107: ,P_Request_Id
2108: ,i.transaction_id
2109: ,l_msg_text
2110: ,'UCCnet'
2111: ,'MTL_SYSTEM_ITEMS_INTERFACE'
2112: ,'INV_IOI_ERR'
2113: ,err_text);
2114:
2115: END IF; -- if not success

Line 2435: FROM MTL_SYSTEM_ITEMS_B

2431: organization_id,
2432: segment1,
2433: unit_weight,
2434: weight_uom_code
2435: FROM MTL_SYSTEM_ITEMS_B
2436: WHERE inventory_item_id = p_inventory_item_id
2437: AND organization_id = p_organization_id;
2438:
2439: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;

Line 2439: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;

2435: FROM MTL_SYSTEM_ITEMS_B
2436: WHERE inventory_item_id = p_inventory_item_id
2437: AND organization_id = p_organization_id;
2438:
2439: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
2440: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL;
2441:
2442: l_msi_attr_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
2443: l_msi_attr_given BOOLEAN := FALSE;

Line 2440: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL;

2436: WHERE inventory_item_id = p_inventory_item_id
2437: AND organization_id = p_organization_id;
2438:
2439: l_unit_weight MTL_SYSTEM_ITEMS.UNIT_WEIGHT%TYPE := NULL;
2440: l_weight_uom_code MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE%TYPE := NULL;
2441:
2442: l_msi_attr_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
2443: l_msi_attr_given BOOLEAN := FALSE;
2444: l_msi_index NUMBER;

Line 2472: FROM mtl_system_items_b

2468:
2469: --Cursor for creating the classification code
2470: CURSOR get_classification_code IS
2471: SELECT item_catalog_group_id
2472: FROM mtl_system_items_b
2473: WHERE inventory_item_id = p_inventory_item_id
2474: AND organization_id = p_organization_id;
2475:
2476: l_inventory_item_id NUMBER;

Line 2807: FROM mtl_system_items_b

2803: );
2804:
2805: -- issue query against MSIB for item_cat_group_id, value for item_id, org_id
2806: SELECT item_catalog_group_id INTO l_item_catalog_group_id
2807: FROM mtl_system_items_b
2808: WHERE inventory_item_id = p_inventory_item_id
2809: AND organization_id = p_org_id;
2810:
2811: px_class_code_name_value_pairs :=

Line 2890: from mtl_system_items_b

2886: ( SELECT ITEM_CATALOG_GROUP_ID
2887: FROM MTL_ITEM_CATALOG_GROUPS_B
2888: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
2889: START WITH ITEM_CATALOG_GROUP_ID = (select item_catalog_group_id
2890: from mtl_system_items_b
2891: where inventory_item_id = p_inventory_item_id
2892: and organization_id = p_organization_id) );
2893: RETURN(TRUE);
2894:

Line 3711: FROM MTL_SYSTEM_ITEMS_B

3707: l_error_rec := SYSTEM.EGO_PAGEWISE_ERROR_REC(NULL, '', '', '');
3708:
3709: BEGIN
3710: SELECT ITEM_CATALOG_GROUP_ID INTO l_catalog_group_id
3711: FROM MTL_SYSTEM_ITEMS_B
3712: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3713: AND ORGANIZATION_ID = p_organization_id;
3714: EXCEPTION WHEN OTHERS THEN
3715: l_error_table.EXTEND;

Line 4436: ' FROM MTL_SYSTEM_ITEMS_B MSI,EGO_ITEM_CUST_ATTRS_B C ' ||

4432:
4433: -- 15. MIN_TRADE_ITEM_LIFE_ARR can not be more than MIN_TRADE_ITEM_LIFE_PROD
4434: BEGIN
4435: l_sql := ' SELECT NVL(C.MIN_TRADE_ITEM_LIFE_ARR, MSI.SHELF_LIFE_DAYS) MIN_TRADE_ITEM_LIFE_ARR ' ||
4436: ' FROM MTL_SYSTEM_ITEMS_B MSI,EGO_ITEM_CUST_ATTRS_B C ' ||
4437: ' WHERE C.PARTY_SITE_ID (+) = :party_site_id ' ||
4438: ' AND MSI.INVENTORY_ITEM_ID = :p_inventory_item_id ' ||
4439: ' AND MSI.ORGANIZATION_ID = :p_organization_id ' ||
4440: ' AND MSI.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID (+) '||

Line 4976: ' FROM MTL_SYSTEM_ITEMS_B MSI,EGO_ITEM_CUST_ATTRS_B C ' ||

4972:
4973: -- 15. MIN_TRADE_ITEM_LIFE_ARR can not be more than MIN_TRADE_ITEM_LIFE_PROD
4974: BEGIN
4975: l_sql := ' SELECT NVL(C.MIN_TRADE_ITEM_LIFE_ARR, MSI.SHELF_LIFE_DAYS) MIN_TRADE_ITEM_LIFE_ARR ' ||
4976: ' FROM MTL_SYSTEM_ITEMS_B MSI,EGO_ITEM_CUST_ATTRS_B C ' ||
4977: ' WHERE C.PARTY_SITE_ID (+) = :party_site_id ' ||
4978: ' AND MSI.INVENTORY_ITEM_ID = :p_inventory_item_id ' ||
4979: ' AND MSI.ORGANIZATION_ID = :p_organization_id ' ||
4980: ' AND MSI.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID (+) '||