APPS.EGO_GTIN_ATTRS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1839: FROM EGO_ITEM_GTN_ATTRS_VL gtn, MTL_SYSTEM_ITEMS_B msib

1835: ,gtn.PEG_HORIZONTAL
1836: ,gtn.PEG_VERTICAL
1837: ,gtn.GENERIC_INGREDIENT
1838: ,gtn.UOM_NET_CONTENT
1839: FROM EGO_ITEM_GTN_ATTRS_VL gtn, MTL_SYSTEM_ITEMS_B msib
1840: WHERE gtn.INVENTORY_ITEM_ID(+) = msib.INVENTORY_ITEM_ID
1841: AND gtn.ORGANIZATION_ID(+) = msib.ORGANIZATION_ID
1842: AND msib.INVENTORY_ITEM_ID = p_inventory_item_id
1843: AND msib.ORGANIZATION_ID = p_organization_id;

Line 1870: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;

1866: AND ORGANIZATION_ID = p_organization_id;
1867:
1868: l_prod_single_row_attrs c_prod_single_row_values%ROWTYPE;
1869:
1870: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1871: l_gdsn_outbound_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;
1872: l_is_used_in_packaging_hrchy VARCHAR2(10);
1873: l_err_msg VARCHAR2(1000);
1874: l_err_code NUMBER;

Line 1871: l_gdsn_outbound_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;

1867:
1868: l_prod_single_row_attrs c_prod_single_row_values%ROWTYPE;
1869:
1870: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1871: l_gdsn_outbound_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;
1872: l_is_used_in_packaging_hrchy VARCHAR2(10);
1873: l_err_msg VARCHAR2(1000);
1874: l_err_code NUMBER;
1875: l_bgln_valid BOOLEAN;

Line 1951: FROM MTL_SYSTEM_ITEMS_B

1947: Debug_Msg('Checking if Item is GDSN Enabled item');
1948:
1949: BEGIN
1950: SELECT GDSN_OUTBOUND_ENABLED_FLAG INTO l_gdsn_outbound_flag
1951: FROM MTL_SYSTEM_ITEMS_B
1952: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1953: AND ORGANIZATION_ID = p_organization_id;
1954: EXCEPTION WHEN NO_DATA_FOUND THEN
1955: IF NVL(G_CALLED_FROM_INTF, 'N') = 'Y' THEN

Line 3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;

3888: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3889: l_new_row BOOLEAN;
3890: l_row_identifier NUMBER;
3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3896: l_category_id NUMBER;

Line 4033: FROM MTL_SYSTEM_ITEMS_B

4029: END LOOP;
4030: END IF;
4031:
4032: SELECT ITEM_CATALOG_GROUP_ID INTO l_category_id
4033: FROM MTL_SYSTEM_ITEMS_B
4034: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
4035: AND ORGANIZATION_ID = p_organization_id;
4036:
4037: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY( EGO_COL_NAME_VALUE_PAIR_OBJ( 'INVENTORY_ITEM_ID' , TO_CHAR(p_inventory_item_id))

Line 4054: FROM MTL_SYSTEM_ITEMS_B

4050:
4051: Debug_Msg('Checking the Trade Item Descriptor');
4052: BEGIN
4053: SELECT TRADE_ITEM_DESCRIPTOR INTO l_trade_item_desc
4054: FROM MTL_SYSTEM_ITEMS_B
4055: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
4056: AND ORGANIZATION_ID = p_organization_id;
4057: EXCEPTION WHEN NO_DATA_FOUND THEN
4058: l_trade_item_desc := NULL;