DBA Data[Home] [Help]

APPS.EGO_GTIN_ATTRS_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 1958: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

1954: EXCEPTION WHEN NO_DATA_FOUND THEN
1955: IF NVL(G_CALLED_FROM_INTF, 'N') = 'Y' THEN
1956: BEGIN
1957: SELECT GDSN_OUTBOUND_ENABLED_FLAG INTO l_gdsn_outbound_flag
1958: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
1959: WHERE SET_PROCESS_ID = G_DATA_SET_ID
1960: AND PROCESS_FLAG = 1
1961: AND INVENTORY_ITEM_ID = p_inventory_item_id
1962: AND ORGANIZATION_ID = p_organization_id

Line 1991: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

1987:
1988: IF NVL(G_CALLED_FROM_INTF, 'N') = 'Y' THEN
1989: BEGIN
1990: SELECT TRADE_ITEM_DESCRIPTOR INTO l_trade_item_desc
1991: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
1992: WHERE SET_PROCESS_ID = G_DATA_SET_ID
1993: AND PROCESS_FLAG = 1
1994: AND INVENTORY_ITEM_ID = p_inventory_item_id
1995: AND ORGANIZATION_ID = p_organization_id