DBA Data[Home] [Help]

APPS.AHL_RM_MATERIAL_AS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1331: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

1327: CURSOR get_comms_nl_trackable_flag ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
1328: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
1329: IS
1330: SELECT DISTINCT MI.comms_nl_trackable_flag
1331: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
1332: WHERE MP.organization_id = MI.organization_id
1333: AND MI.inventory_item_id = c_inventory_item_id
1334: AND MI.organization_id = c_inventory_org_id
1335: AND MI.enabled_flag = 'Y'

Line 1982: FROM MTL_SYSTEM_ITEMS_KFV MTL

1978: MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;
1979: CURSOR get_item_number ( c_inventory_item_id NUMBER, c_inventory_master_org_id NUMBER )
1980: IS
1981: SELECT mtl.concatenated_segments
1982: FROM MTL_SYSTEM_ITEMS_KFV MTL
1983: WHERE
1984: mtl.ORGANIZATION_ID(+) = c_inventory_item_id AND
1985: mtl.inventory_item_id(+) = c_inventory_master_org_id;
1986: CURSOR get_mc_name_and_revision ( c_mc_id NUMBER, c_mc_header_id NUMBER )