APPS.EGO_GTIN_PVT dependencies on MTL_CROSS_REFERENCES

Line 65: MTL_CROSS_REFERENCES MCR,

61: (
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

Line 933: FROM MTL_CROSS_REFERENCES MCR,

929: IS
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

Line 1375: l_gtin MTL_CROSS_REFERENCES.CROSS_REFERENCE%TYPE;

1371: l_action_map Bom_Rollup_Pub.Rollup_Action_Map := Bom_Rollup_Pub.G_EMPTY_ACTION_MAP;
1372: l_structure_type_name VARCHAR2(200);
1373: x_error_message VARCHAR2(2000);
1374: l_rollup_reqd BOOLEAN := FALSE;
1375: l_gtin MTL_CROSS_REFERENCES.CROSS_REFERENCE%TYPE;
1376:
1377: l_start_availability_date_time EGO_ITEM_CUST_ATTRS_B.START_AVAILABILITY_DATE_TIME%TYPE;
1378: l_end_availability_date_time EGO_ITEM_CUST_ATTRS_B.END_AVAILABILITY_DATE_TIME%TYPE;
1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;

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 1586: l_gtin MTL_CROSS_REFERENCES.CROSS_REFERENCE%TYPE;

1582: x_return_status OUT NOCOPY VARCHAR2,
1583: x_msg_count OUT NOCOPY NUMBER,
1584: x_msg_data OUT NOCOPY VARCHAR2) AS
1585: x_error_message VARCHAR2(2000);
1586: l_gtin MTL_CROSS_REFERENCES.CROSS_REFERENCE%TYPE;
1587: l_view_name VARCHAR2(100);
1588: l_select_columns VARCHAR2(32000);
1589: l_sql VARCHAR2(32000);
1590: l_value VARCHAR2(15000);