APPS.AHL_RM_MATERIAL_AS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1327: CURSOR get_comms_nl_trackable_flag ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

1323: x_return_status OUT NOCOPY VARCHAR2
1324: )
1325: IS
1326:
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

Line 1328: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )

1324: )
1325: IS
1326:
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

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 1339: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;

1335: AND MI.enabled_flag = 'Y'
1336: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
1337: AND NVL( MI.end_date_active, SYSDATE );
1338:
1339: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;
1340: BEGIN
1341: x_return_status := FND_API.G_RET_STS_SUCCESS;
1342:
1343: IF ( p_material_req_rec.dml_operation <> 'D' ) THEN

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 )